Example

The following example creates a combo box cell that allows automatic searching. The control will display the closest matching item in the list in the edit field when the user types a character.

C++

m_Spread1.Col(2);
m_Spread1.Row(2);
m_Spread1.CellType(CellTypeComboBox);
m_Spread1.TypeComboBoxEditable(TRUE);
m_Spread1.TypeComboBoxList("Raleigh\tCary\tDurham\tChapel Hill");
m_Spread1.TypeComboBoxAutoSearch(TypeComboBoxAutoSearchSingleCharGreater)

Visual Basic

fpSpread1.Col = 2
fpSpread1.Row = 2
fpSpread1.CellType = CellTypeComboBox
fpSpread1.TypeComboBoxEditable = True
fpSpread1.TypeComboBoxList = "Raleigh" & Chr(9) & "Cary" & Chr(9) & "Durham" & Chr(9) & "Chapel Hill"
fpSpread1.TypeComboBoxAutoSearch = TypeComboBoxAutoSearchSingleCharGreater