ActiveX
To create and set up a combo box cell
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col, Col2, Row, and Row2 properties as appropriate.
- If you are selecting a block of cells, set the BlockMode property to True.
- Set the CellType property to 8 (Combo Box).
-
If you want to allow users to type one or more characters to search for an item in the list,
- Set the TypeComboBoxEditable property to False.
- Set the TypeComboBoxAutoSearch property to a value other than 0 (None).
- If you want the combo box to act as a drop-down combo box, set the TypeComboBoxEditable property to True.
- Specify the horizontal and vertical alignment of the text in the edit field with the TypeHAlign and TypeVAlign properties.
- Provide list items for the combo box by providing a string of tab-delimited items using the TypeComboBoxList property.
- Specify the maximum number of characters allowed in the cell using the TypeMaxEditLen property.
- Specify the number of rows in the drop-down list with the TypeComboBoxMaxDrop property.
- If you selected a block of cells, set the BlockMode property back to False.