Shape.ControlFormat Property (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a ControlFormat object that contains Microsoft Excel control properties. Read-only.

expression .ControlFormat

expression A variable that represents a Shape object.

This example removes the selected item from a list box. If Shapes(2) doesn’t represent a list box, this example fails.

Set lbcf = Worksheets(1).Shapes(2).ControlFormat 
lbcf.RemoveItem lbcf.ListIndex

Concepts

Other resources

Show: