Edit

Share via

ControlFormat.RemoveAllItems method (Excel)

  • Article

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.