Conditionally
executes a group of statements, depending on the value of an expression.
Synopsis
If condition Then statements [Else elsestatements ]
Or, you can use the block form syntax:
If condition Then
[statements]
[ElseIf condition-n Then
[elseifstatements]] . . .
[Else
[elsestatements]]
End If
You can use the single-line form (first syntax) for short, simple tests.
However, the block form (second syntax) provides more structure and flexibility
than the single-line form and is usually easier to read, maintain, and debug.
When executing a block
If (second syntax), condition
is tested. If condition is
True, the statements following
Then are
executed. If condition is
False, each
ElseIf (if
any) is evaluated in turn. When a
True condition is found,
the statements following the associated
Then are executed.
If none of the
ElseIf statements are
True (or
there are no
ElseIf clauses), the statements following
Else are
executed. After executing the statements following
Then or
Else,
execution continues with the statement following
End If.
The
Else and
ElseIf clauses
are both optional. You can have as many
ElseIf statements
as you want in a block
If, but none can appear after
the
Else clause. Block
If statements
can be nested; that is, contained within one another.
What follows the
Then keyword is examined to determine
whether or not a statement is a block
If. If anything
other than a comment appears after
Then on the same line,
the statement is treated as a single-line
If statement.
A block
If statement must be the first statement
on a line. The block
If must end with an
End
If statement.
With the single-line syntax, it is possible to have multiple statements
executed as the result of an
If...Then decision, but
they must all be on the same line and separated by colons, as in the following
statement:
If A > 10 Then A = A + 1 : B = B + A : C = C + B