Link Search Menu Expand Document

SSpread.TypeComboBoxCurSel Property

Set the index number of the item to be selected in a combo box type cell.

Only valid for cells with the CellType property set to $CellTypeComboBox . Before setting this property, use the Col , Row properties etc. to specify the cell of interest.

Specify an index number starting from 0 . The initial value is -1 (unselected).

You can get the number of items in the list with the TypeComboBoxCount property.

Notes on property inheritance of combo box type cells

Use case

Col = 3;
Row = 2;
CellType = $CellTypeComboBox;
TypeComboBoxList = "AAA\tBBB\tCCC\tDDD\tEEE";
TypeComboBoxCurSel = 2;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeComboBox;
TypeComboBoxCurSel = 3;
BlockMode = $FALSE;

Related item
CellType , TypeComboBoxCount , TypeComboBoxList property