Excel: IF-THEN-ELSE Statement (VBA only)

--------------------------------------------------------------------------------

In Excel, the IF-THEN-ELSE statement can only be used in VBA code.

The syntax for the IF-THEN-ELSE statement is:

If condition_1 Then
result_1

ElseIf condition_2 Then
result_2
...
ElseIf condition_n Then
result_n

Else
result_else

End If

condition_1 to condition_n are evaluated in the order listed. Once a condition is found to be true, the IF-THEN-ELSE statement will execute the corresponding code and not evaluate the conditions any further.

result_1 to result_n is the code that is executed once a condition is found to be true.



Note:

If no condition is met, then the Else portion of the IF-THEN-ELSE statement will be executed.

It is important to note that the ElseIf and Else portions are optional.



Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000


VBA Code
The IF-THEN-ELSE statement can only be used in VBA code.
First, let's take a look at a simple example.

If LRegion ="N" Then
LRegionName = "North"
End If



Next, let's take a look at an example that uses ElseIf.

If LRegion ="N" Then
LRegionName = "North"

ElseIf LRegion = "S" Then
LRegionName = "South"

ElseIf LRegion = "E" Then
LRegionName = "East"

ElseIf LRegion = "W" Then
LRegionName = "West"

End If



Finally, let's take a look at an example that uses Else.

If LRegion ="N" Then
LRegionName = "North"

ElseIf LRegion = "S" Then
LRegionName = "South"

ElseIf LRegion = "E" Then
LRegionName = "East"

Else
LRegionName = "West"

End If