ControlFormat.RemoveAllItems Method (Excel)
Removes all entries from a Microsoft Excel list box or combo box.
Syntax
expression .RemoveAllItems
expression A variable that represents a ControlFormat object.
Example
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