This documentation is archived and is not being maintained.

Shape.ControlFormat Property

Office 2007
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.

Visual Basic for Applications
Set lbcf = Worksheets(1).Shapes(2).ControlFormat
lbcf.RemoveItem lbcf.ListIndex



Show: