| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
ControlFormat.AddItem method (Excel) |
vbaxl10.chm630073 |
|
|
fffc243b-3f94-14ab-f7b4-83c56325aa5e |
04/23/2019 |
medium |
Adds an item to a list box or a combo box.
expression.AddItem (Text, Index)
expression A variable that represents a ControlFormat object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Text | Required | String | The text to be added. |
| Index | Optional | Variant | 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. |
Using this method clears any range specified by the ListFillRange property.
This example creates a list box and fills it with integers from 1 to 10.
With Worksheets(1)
Set lb = .Shapes.AddFormControl(xlListBox, 100, 10, 100, 100)
For x = 1 To 10
lb.ControlFormat.AddItem x
Next
End With[!includeSupport and feedback]