Example

The following example creates a sheet that has a second column of combo box cells. The combo box cells provide a list of items the user can select from, or the user can type into the combo box edit field. The combo box limits content to 10 characters or less. Only the active combo box cell in the column displays its drop-down button. The contents of the edit field for the combo boxes are vertically centered in the cell.

C++

void CmyWnd::MyFunc()
{
    // Specify the second column as combo box cells
    fpSpread1.SetRow(-1);
    fpSread1.SetCol(2);
    fpSpread1.SetCellType(CellTypeComboBox);
    // Display the button in the current cell only
    fpSpread1.SetButtonDrawMode(ButtonDrawModeCurrentCell);
    // Allow up to 10 characters in the edit field
    fpSpread1.SetTypeMaxEditLen(10);
    // Center the text in the edit field vertically
    fpSpread1.SetTypeVAlign(TypeVAlignCenter);
    // Let users type text in the edit field
    fpSpread1.SetTypeComboBoxEditable(True);
    // Provide a drop-down list for the combo box
    fpSpread1.SetTypeComboBoxList("North\tSouth\tEast\tWest");
}

Visual Basic

Sub Form_Load()
    ' Specify the second column as combo box cells
    fpSpread1.Col = 2
    fpSpread1.Row = -1
    fpSpread1.CellType = CellTypeComboBox
    ' Display the button in the current cell only
    fpSpread1.ButtonDrawMode = ButtonDrawModeCurrentCell
    ' Allow up to 10 characters in the edit field
    fpSpread1.TypeMaxEditLen = 10
    ' Center the text in the edit field vertically
    fpSpread1.TypeVAlign = TypeVAlignCenter
    ' Let users type text in the edit field
    fpSpread1.TypeComboBoxEditable = True
    ' Provide a drop-down list for the combo box
    fpSpread1.TypeComboBoxList = "North" + Chr$(9) + "South" + Chr$(9) + "East" + Chr$(9) + "West"
End Sub