RemoveAllItems Method

Microsoft Excel Visual Basic

RemoveAllItems Method

       

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.

expression.RemoveAllItems

expression   Required. An expression that returns 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