ControlFormat.AddItem(String, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Adds an item to a list box or a combo box.

public void AddItem (string Text, object Index);

Public Sub AddItem (Text As String, Optional Index As Object)

Parameters

Text: String

Required String. The text to be added

Index: Object

Optional Object. The position of the new entry. If the list has fewer entries than the specified index, blank items from the end of the list are added to the specified position. If this argument is omitted, the item is appended to the existing list.

Remarks

Using this method clears any range specified by the ListFillRange property.

Applies to