Choose Function

Syntax:

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

Group:

Flow Control

Description: 

Returns the value of the expr indicated by Index.

Parameters:

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.

Example:

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

See Also:

If, Select Case, IIf( ).