ListBox
Inserts a drop-down list control in the spreadsheet.
ListBox Inputs
Syntax: ListBox("String0","String1","String2",...)
Parameter | Description |
---|---|
A variable-length list of individual text strings, each of which returns a different value when selected by a user from the drop-down list. |
ListBox Outputs
Returns |
A value representing the index number (zero-based) of the selected item. |
Results |
A ListBox control. Note: The text string
that is currently selected from the list can also be accessed using the
GetString Vision Data Access
function. For more information, see GetString(ListBox)
|
ListBox Example
A spreadsheet is configured as follows:
A3=ListBox("Item1","Item2","Item3")
A4=A3
The function in cell A3 creates the list control, with "Item1" as the default selection. The index value of Item1 is 0, so the value in cell A4 will be 0.000.
If the user selects "Item2", then the value in cell A4 will be 1.000. If "Item3" is selected, the value in cell A4 will be 2.000.
ListBox Vision Data Access Functions
Additional data elements can be accessed using the following Vision Data Access functions:
GetString |
GetString(ListBox) |
Returns the text string. |