TXlsFile.AddComboBox Method
Adds a ComboBox to the active sheet.
Remarks
Excel supports 2 types of comboboxes: ActiveX and internal (In Excel you would add them from the "ActiveX" and "Forms" toolbars respectively) The comboboxes added by this method are of type internal. ActiveX comboboxes are not supported.
Syntax
Unit: FlexCel.XlsAdapter
function TXlsFile.AddComboBox(const anchor: TClientAnchor; const name: string; const linkedCell: TCellAddress; const inputRange: TCellAddressRange; const selectedItem: Integer): Integer; override;
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
const | anchor | TClientAnchor | Position for the combobox. |
const | name | string | Name of the inserted combobox. |
const | linkedCell | TCellAddress | Cell that will be linked to the combobox. Set this to null to not link any cell. |
const | inputRange | TCellAddressRange | Range of cells with the values that the combobox will display. |
const | selectedItem | Integer | Item that will be selected, starting at 1. 0 means no selected item. |
Returns
Object Index of the inserted combobox (1 based).