Example

The following example creates a sheet with a combo box list in cell B2. One command button will clear the list. Another command button will delete one list item at a time.

C++

void CTestDlg::OnShowWindow(BOOL bShow, UINT nStatus)
{

    m_Command1.SetWindowText("Clear List");
    m_Command1.SetWindowText ("Delete Item");
    m_Spread1.SetRow(2);
    m_Spread1.SetCol(2);
    m_Spread1.SetCellType(CellTypeComboBox);
    m_Spread1.SetTypeComboBoxList("Item1\tItem2\tItem3");
}

void CTestDlg::OnButton1()
{
    m_Spread.TypeComboBoxClear(2, 2);
}

    void CTestDlg::OnButton2()
{
    int nItem;
    nItem = m_Spread1.GetTypeComboBoxIndex()
    m_Spread1.TypeComboBoxRemoveItem(2, 2, nItem);
}

Visual Basic

Private Sub Command1_Click()
    fpSpread1.TypeComboBoxClear 2, 2
End Sub

Private Sub Command2_Click()
    Dim Item As Integer
    Item = fpSpread1.TypeComboBoxIndex
    fpSpread1.TypeComboBoxRemoveItem 2, 2, Item
End Sub

Private Sub Form_Load()
    Command1.Caption = "Clear List"
    Command2.Caption = "Delete Item"
    fpSpread1.Col = 2
    fpSpread1.Row = 2
    fpSpread1.CellType = CellTypeComboBox
    fpSpread1.TypeComboBoxList = "Item1" & Chr(9) & "Item2" & Chr(9) & "Item3"
End Sub