comboIndex

Type: Integer

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

The comboIndex property of the Table class contains the index of a combo box in a cell of a Table control.

This property applies only to a cell that has the inputType property set to InputType_ComboBox (3). The current sheet, row, and column properties determine the cell to which the reference applies.

When such a cell is selected, a combo box filled with list entries replaces the displayed text. Using the comboList property sets this list. The combo box entry that is selected is determined by the setting of comboIndex property (1-relative).

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 -1 (that is, no entry is selected).

This property is not affected by the accessMode, accessedSheet, accessedRow, accessedColumn, or accessedCell property, as the property always applies to the current cell.