If-Then-Else format
If <conditional expression> Then
<one or more statements to be executed if condition is true>
Else
<one or more statements to be executed if condition is false>
End If
If-Then format
If <conditional expression> Then
<one or more statements to be executed if condition is true>
End If
Null format
If <conditional expression> Then ‘do nothing
Else <one or more statements to be executed if condition is false>
End If
If statement as single line
If <conditional expression> Then <true statement> [Else <false statement>]
Extended block If (If-Then-ElseIf) format
If <conditional expression 1> Then
<one or more statements to be executed if condition 1 is true>
ElseIf <conditional expression 2> Then
<one or more statements to be executed if condition 2 is true>
...
ElseIf <conditional expression n> Then
<one or more statements to be executed if condition n is true>
Else
<one or more statements to be executed if none of the above conditions is true>
End If
Select Case format
Select Case <test expression>
Case <expression list 1>
<statement list 1>
Case <expression list 2>
<statement list 2>
Case Else
<statement list n>
End Select