ActiveX

To create a combo box cell using the fpCombo control

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Set the Col, Row, Col2, and Row2 properties to specify the cell or block of cells.
3. If you are selecting a block of cells, set the BlockMode property to True.
4. Set the CellType property to 8 (Combo Box).
5. If you selected a block of cells, set the BlockMode property back to False.
6. At run time, set the TypeComboBoxhWnd property to the window handle of the fpCombo control.
7. For the fpCombo control, either hide the control or set the Visible property to False.