Shape.ControlFormat property (Excel)

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

Syntax

expression.ControlFormat

expression A variable that represents a Shape object.

Example

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

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.