How to Use IF Statement with VBA in Excel: Simple Guide

In Excel VBA, use the If statement to run code only when a condition is true. The basic form is If condition Then followed by the code to run, and optionally Else for other cases. This helps automate decisions in your macros.

Syntax

The If statement in VBA checks a condition and runs code based on whether the condition is true or false.

• If condition Then: Starts the check. If the condition is true, the next code runs.
• Else: (Optional) Runs code if the condition is false.
• End If: Ends the If block.

vba

If condition Then
    ' Code to run if condition is true
Else
    ' Code to run if condition is false
End If

Example

This example checks if a number in cell A1 is greater than 10. It shows a message box with "Greater than 10" if true, otherwise "10 or less".

vba

Sub CheckNumber()
    Dim num As Integer
    num = Range("A1").Value
    If num > 10 Then
        MsgBox "Greater than 10"
    Else
        MsgBox "10 or less"
    End If
End Sub

Output

If A1 = 15, message box shows: Greater than 10
If A1 = 8, message box shows: 10 or less

Common Pitfalls

Common mistakes when using If in VBA include:

• Forgetting End If when using multi-line If blocks.
• Using single-line If without Then or with incorrect syntax.
• Not handling cases when the cell is empty or contains text instead of a number.

Always test your conditions carefully.

vba

'' Wrong: Missing End If
If num > 10 Then
    MsgBox "Greater than 10"

'' Correct:
If num > 10 Then
    MsgBox "Greater than 10"
End If

Quick Reference

Part	Description	Example
If condition Then	Checks if condition is true	If x > 5 Then
Else	Runs if condition is false	Else
ElseIf condition Then	Checks another condition if first is false	ElseIf x = 5 Then
End If	Ends the If block	End If

Key Takeaways

Use If...Then...Else to run code based on conditions in VBA.

Always close multi-line If statements with End If.

Test your conditions to avoid errors with empty or wrong data types.

Single-line If statements do not need End If but must be on one line.

Use ElseIf to check multiple conditions in sequence.