|Choices:||Comma-separated list of items or an object reference containing a list of items to be shown|
|Default:||Select default choice from list provided in Choices: above|
|Range Reference:||Select NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet
Only references to a single cell are accepted
|Visible Choices:||Comma separated list of items or a LIST reference containing a list of items visible to user
Actual selected value of CHOICE LIST will evaluate to the value in Choices: at the corresponding location in list
|Label:||Text displayed to the left of CHOICE LIST|
|Select Mode:||Select type (default: STANDARD, SINGLE SELECT, DISTRIBUTED LIST, SINGLE SELECT RADIO BUTTON)|
|Orientation:||Specify orientation of Choices: in Radio Button mode (default→VERTICAL, HORIZONTAL)|
|Number of Lines:||Set number of visible lines in this CHOICE LIST|
|Delimiter:||Set character to delimit an object reference in Choices: or Label: above (default: % )|
|Tool Tip:||Text to display as a tool tip|
|Show if:||Logical expression, if TRUE then list shown, if FALSE then list NOT shown|
|Enable if:||Logical expression, if TRUE then list enabled, if FALSE then list NOT enabled|
|Label Width:||Width in pixels of Label:|
|Style:||A USER INTERFACE STYLE or object reference that controls the visual appearance of this objects background|
|Input Style:||A USER INTERFACE STYLE or object reference that controls the visual appearance of this objects input area|
|Tab Index:||Establish an order of preference for <TAB> key navigation (default: 0 )
<TAB> delivers focus to Tab Index: 1 then 2 and continues in ascending numerical order
After the highest set Tab Index: value, focus is delivered to Tab Index: 0
Tab Index: -1 will completely exclude this object from <TAB> focus selection
|List Separator:||A string to replace the comma character’s role as separator in Choices:
only available if Select Mode: DISTRIBUTED LIST
Choose from four types of CHOICE LIST in Select Mode:
The STANDARD type is the default. It appears like a pull-down menu with only the selected item shown in the input box. With a STANDARD CHOICE LIST a User may select only one of the available choices. An example of a 'STANDARD' CHOICE LIST is shown below.
A 'SINGLE SELECT' CHOICE LIST appears differently from the STANDARD type in that more than one of the available choices can be visible inside the input box. However, like STANDARD a User may select only one of the available choices. The figure below shows an example of a 'SINGLE SELECT' CHOICE LIST.
A 'DISTRIBUTED LIST' CHOICE LIST looks just like 'SINGLE SELECT'. However, users can now select multiple non-consecutive choices by holding down either the ‘Shift’ or ‘Ctrl’ key when clicking on their choices.
A 'SINGLE SELECT RADIO BUTTON' CHOICE LIST positions a circular radio button next to each individual choice.
Like the 'STANDARD' and 'SINGLE SELECT', a User may select only one of the available choices.
Below shows a 'SINGLE SELECT RADIO BUTTON' CHOICE LIST using the default orientation of 'Vertical'.
Orientation: may change the default orientation to 'Horizontal'
Leading and trailing spaces around an item in the comma-separated list in Choices: are ignored.
An Author may wish to use a READ EXCEL ACTION for a range of Excel cells to set the User-options in Choices:
And then CHOICE LIST selection by the User may be used to update a target cell in the spreadsheet.
To do this an Author will set a spreadsheet cell as a RANGE REFERENCE in the CHOICE LIST' s Range Reference: parameter, the cell will auto-update the output cell value when the User makes a selection.