VB & VBA in a Nutshell: The Language

Select Case Statement

Syntax

Select Case testexpression
   [Case expressionlist-n
      [statements-n]] ...
   [Case Else
      [elsestatements]]
End Select

testexpression

Use: Required

Data Type: Any

Any numeric or string expression whose value determines which block of code is executed.

expressionlist-n

Use: Required

Data Type: Any

Comma-delimited list of expressions to compare values with testexpression.

statements-n

Use: Optional

Program statements to execute if a match is found between any section of expressionlist and testexpression.

elsestatements

Use: Optional

Program statements to execute if a match between testexpression and any expressionlist can't be found.

expressionlist can use any (or a combination of any) of the following:

expressionlist Syntax	Examples
expression	iVar - iAnotherVar iVar
expression To expression	5 To 10 8 To 11, 13 to 15 "A" To "D"
Is comparisonoperator expression	Is = 10

Description

Allows for conditional execution of a block of code, typically out of three or more code blocks, based on some condition. Use the Select Case statement as an alternative to complex nested If...Then...Else statements.

Rules at a Glance

• Any number of Case clauses can be included in the Select Case statement.

• If a match between testexpression and any part of expressionlist is found, the program statements following the matched expressionlist are executed. When program execution encounters the next Case clause or the End Select clause, execution continues with the statement immediately ...