RemoveAllItems Method
Applies To
ControlFormat object.
Description
Removes all entries from a Microsoft Excel list box or combo box. Use the Clear method to remove all items from an ActiveX list box or combo box.
Syntax
expression.RemoveAllItems
expression Required. An expression that returns a ControlFormat object.
See Also
AddItem method, List method, RemoveItem method.
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