Table of Contents

XlsFile.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

Namespace: FlexCel.XlsAdapter

public override Int32 AddComboBox(TClientAnchor anchor, String name, TCellAddress linkedCell, TCellAddressRange inputRange, Int32 selectedItem)

Parameters

<-> Parameter Type Description
anchor TClientAnchor Position for the combobox.
name String Name of the inserted combobox.
linkedCell TCellAddress Cell that will be linked to the combobox. Set this to null to not link any cell.
inputRange TCellAddressRange Range of cells with the values that the combobox will display.
selectedItem Int32 Item that will be selected, starting at 1. 0 means no selected item.

Returns

Object Index of the inserted combobox (1 based).

See also