ControlFormat Object

Description

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.