VB & VBA in a Nutshell: The Language

#If...Then...#Else Directive

Named Arguments

No

Syntax

#If expression Then
   statements
[#ElseIf furtherexpression Then
   [elseifstatements]]
[#Else
   [elsestatements]]
#End If

expression

Use: Required

An expression made up of operators and conditional compiler constants that evaluate to True or False.

statements

Use: Required

One or more lines of code that are executed if expressionevaluates to True.

furtherexpression

Use: Optional

An expression made up of operators and conditional compiler constants that evaluates to True or False. furtherexpression is evaluated only if the preceding expression evaluates to False.

elseifstatements

Use: Optional

One or more lines of code that are executed if furtherexpression evaluates to True.

elsestatements

Use: Optional

One or more lines of code that are executed if expression or furtherexpression evaluates to False.

Description

Defines a block or blocks of code that are included in the compiled application only when a particular condition is met, allowing you to create more than one version of the application using the same source code. Conditionally including a block of code is a two-step process:

• Using the #Const directive to assign a value to a conditional compiler constant

• Evaluating the conditional compiler constant using #If...Then...#End If statement block.

As with the standard If...Then statement, only expressions that evaluate to True are executed directly after the statement. You can use the #Else statement to execute code when the ...