Link Search Menu Expand Document

SSpread.TypeComboBoxEditable Property

Set whether the display text can be edited in a combo box type cell.

Only valid for cells with the CellType property set to $CellTypeComboBox (combo box type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

Specify $TRUE if you want the display text to be editable , and $FALSE if you want the display text to always be selected from the list items . The initial value is $FALSE.

If $TRUE is specified, the display text can be obtained and set with the Text property.

This property is subject to property inheritance of combo box type cells .

Notes on property inheritance of combo box type cells

Use case

Col = 3;
Row = 2;
CellType = $ CellTypeComboBox;
TypeComboBoxEditable = $TRUE;
TypeComboBoxList = "AAA \ tBBB \ tCCC";
Text = "XYZ";
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $ CellTypeComboBox;
TypeComboBoxEditable = $TRUE;
BlockMode = $ FALSE;

Related item
CellType , Text property