Choose Function

Syntax:

Choose(Index, expr[, ...])

 

Group:

Flow Control

 

Description:
 

Return the value of the expr indicated by Index.

Parameter

Description

Index

The numeric value indicates which expr to return. If this value is less than one or greater than the number of exprs then Null is returned.

expr

All expressions are evaluated.

 

 

See Also:

If, Select Case, IIf( ).

 

Example:


Sub Main
  Debug.Print Choose(2,"Hi","there") '"there"
End
Sub