O'Reilly logo

VB & VBA in a Nutshell: The Language by Paul Lomax

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

#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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required