| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
ControlFormat.RemoveAllItems method (Excel) |
vbaxl10.chm630074 |
|
|
de8e1721-45e1-eca9-d35d-7d72c32dc0bf |
04/23/2019 |
medium |
Removes all entries from a Microsoft Excel list box or combo box.
expression.RemoveAllItems
expression A variable that represents a ControlFormat object.
This example removes all items from a list box. If Shapes(2) doesn't represent a list box, this example fails.
Worksheets(1).Shapes(2).ControlFormat.RemoveAllItems[!includeSupport and feedback]