Conditional Statements Format Reference

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