ControlFormat Object [Excel 2003 VBA Language Reference]

  • Article
Shape
ControlFormat

Contains Microsoft Excel control properties.

Using the ControlFormat Object

Use the ControlFormat property to return a ControlFormat object. The following example sets the fill range for a list box control on worksheet one.

Worksheets(1).Shapes(1).ControlFormat.ListFillRange = "A1:A10"

If the shape isn't a control, the ControlFormat property fails; and if the control isn't a list box, the ListFillRange property fails.

Properties | Application Property | Creator Property | DropDownLines Property | Enabled Property | LargeChange Property | LinkedCell Property | ListCount Property | ListFillRange Property | ListIndex Property | LockedText Property | Max Property | Min Property | MultiSelect Property | Parent Property | PrintObject Property | SmallChange Property | Value Property

Methods | AddItem Method | List Method | RemoveAllItems Method | RemoveItem Method

Parent Objects | Shape Object

Child Objects