ControlFormat.RemoveAllItems Method

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.

Visual Basic for Applications
`Worksheets(1).Shapes(2).ControlFormat.RemoveAllItems`

Clear the contents of a list box? Empty listbox? Erase all items from listbox? remove remove all items Remove All Items Method removeall RemoveAllItems RemoveAllItems Method

Removes all entries from a Microsoft Excel list box or combo box.

See also: