comboList

Type: String

Availability: Read or write at run time only (for a cell with inputType set only to 3, for a combo box)

The comboList property contains the list entries displayed in a combo box in the sheet, column, row, or cell of a Table control. This property applies only to a cell that has an effective inputType property set to InputType_ComboBox (3).

The current sheet, row, and column properties determine the cell to which the reference applies. This property is affected by the rules that apply to the accessMode, accessedSheet, accessedRow, accessedColumn, or accessedCell property. When such a cell is selected, a combo box filled with list entries replaces the displayed text. The combo box entry that is selected is determined by the setting of the comboIndex property (1-relative).

The value of the comboList property is set by using a single string, with list entries separated by a tab character; for example:

table1.comboList := "one" & Tab & "two" & Tab & "three";

When the user selects a combo box entry, the value of the comboIndex property is set to the index of the selected entry. The value of the text for the cell is set to the text of the selected list entry. A change event is then caused.

If logic sets the text of the cell, the text must match an entry in the combo box list.

The default value is an empty string (null).