|
Syntax
|
Choose(index,expression1,expression2,...,expression13)
|
|
Description
|
Returns the expression at the specified index position.
|
|
Comments
|
The index parameter specifies which expression is to be returned. If index is 1, then expression1 is returned; if index is 2, then expression2 is returned, and so on. If index is less than 1 or greater than the number of supplied expressions, then
Null
is returned.
The
Choose
function returns the expression without converting its type. Each expression is evaluated before returning the selected one.
|
|
Example
|
This example assigns a variable of indeterminate type to a.
Sub Main()
Dim a As Variant
Dim c As Integer
c% = 2
a = Choose(c%,"Hello, world",#1/1/94#,5.5,False)
MsgBox "Item " & c% & " is '" & a & "'" 'Displays the date passed as parameter 2.
End Sub
|
|
See Also
|
Switch (function); IIf (function); If...Then...Else (statement); Select...Case (statement).
|