ControlFormat Members

Use the ControlFormat object to get and set the properties on Forms 1.0 controls. Use the Shape object’s ControlFormat property to get a reference to this object. The ControlFormat object has the following members:

AddItem

Application

Creator

DropDownLines

Enabled

LargeChange

LinkedCell

List

ListCount

ListFillRange

ListIndex

LockedText

Max

Min

MultiSelect

Parent

PrintObject

RemoveAllItems

RemoveItem

SmallChange

Value

 

Forms 1.0 controls are mostly obsolete. The Forms 2.0 controls provide events, properties, and methods that are not available with the Forms 1.0 controls. See Chapter 20 for information on using Forms 2.0 controls on worksheets.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.