ControlFormat.RemoveAllItems Method

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

See Also

• ControlFormat Object
• ControlFormat Object Members
• AddItem Method
• List Method
• RemoveItem Method