\<bookmark_value\>Choose function\</bookmark_value\>

Choose Function

Returns a selected value from a list of arguments.

Syntax:


Choose (Index, Selection1[, Selection2, ... [,Selection_n]])

Parameters:

\<emph\>Index:\</emph\> A numeric expression that specifies the value to return.

\<emph\>Selection1:\</emph\> Any expression that contains one of the possible choices.

The \<emph\>Choose\</emph\> function returns a value from the list of expressions based on the index value. If Index = 1, the function returns the first expression in the list, if index i= 2, it returns the second expression, and so on.

If the index value is less than 1 or greater than the number of expressions listed, the function returns a Null value.

The following example uses the \<emph\>Choose\</emph\> function to select a string from several strings that form a menu:

Error codes:

5 Invalid procedure call

Example:


Sub ExampleChoose
Dim sReturn As String
    sReturn = ChooseMenu(2)
    Print sReturn
End Sub
 
Function ChooseMenu(Index As Integer)
    ChooseMenu = Choose(Index, "Quick Format", "Save Format", "System Format")
End Function

Please support us!