Choose Function

Syntax

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

Group

Flow Control

Description

Return the value of the expr indicated by 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.

Parameter Description

Index

See Also: If, Select Case, IIf( ).

Example

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