Selects and returns a value from a list of arguments.
Syntax
Choose(index, choice-1[, choice-2, ... [, choice-n]])
The Choose function syntax has these parts:
| Part | Description |
|---|---|
| index | Required. Numeric expression or field that results in a value between 1 and the number of available choices. |
| choice | Required. Variant expression containing one of the possible choices. |
Remarks
Choose returns a value from the list of choices based on the value of index. If index is 1, Choose returns the first choice in the list; if index is 2, it returns the second choice, and so on.
You can use Choose to look up a value in a list of possibilities. For example, if index evaluates to 3 and choice-1 = "one", choice-2 = "two", and choice-3 = "three", Choose returns "three".
Choose evaluates every choice in the list, even though it returns only one. For this reason, you should watch for undesirable side effects. For example, if the evaluation of any expression results in a division by zero error, an error occurs.
The Choose function returns a Null if index is less than 1 or greater than the number of choices listed.
If index is not a whole number, it is rounded down to the next whole number before being evaluated.