Description
The If...Then...Else statement conditionally executes a group of statements, depending on the value of an expression.
This statement has the following forms:
' Block syntax
If condition Then
[statements]
[ElseIf condition-n Then
[elseifstatements]] . . .
[Else
[elsestatements]]
End If
' Single-Line syntax
If condition Then statements [Else elsestatements ]
Parameter | Description |
---|---|
condition | One or more of the following two types of expressions: A numeric or string expression that evaluates to True or False. If condition is Null, condition is treated as False An expression of the form TypeOf objectname Is objecttype. The objectname is any object reference and objecttype is any valid object type. The expression is True if objectname is of the object type specified by objecttype; otherwise it is False. |
statements | One or more statements separated by colons; executed if condition is True |
condition-n | Same as condition |
elseifstatements | One or more statements executed if the associated condition-n is True |
elsestatements | (optional) Specifies the return value of the If...Then...Else |
Examples
The following example shows the basic use of this statement:
If i=10 Then
Msgbox("i is equal to 10")
ElseIf i=20 Then
Msgbox("i is equal to 20")
Else
Msgbox("i is not equal to 10 or 20")
End If
Miscellaneous Information
Supported in Version: | 1.0 |
---|