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