Select Case

This statement executes one of several groups of statements, depending on the value of an expression.

Syntax

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

Parameters

testexpression

Any numeric or string expression.

expressionlist-n

Required if Case appears. Delimited list of one or more expressions.

statements-n

One or more statements executed if testexpression matches any part of expressionlist-n.

elsestatements

One or more statements executed if testexpression does not match any of the Case clauses.

Remarks

If testexpression matches any Case expressionlist expression, the statements following that Case clause are executed up to the next Case clause, or for the last clause, up to End Select. Control then passes to the statement following End Select. If testexpression matches an expressionlist expression in more than one Case clause, only the statements following the first match are executed.

The Case Else clause indicates the elsestatements to be executed if no match is found between the testexpression and an expressionlist in any of the other Case selections.