Control and Controls Members

Use the Controls collection to add new controls dynamically at runtime and to perform general operations on all of the controls on a form. Use the UserForm object’s Controls property to get a reference to this collection. Use the Control object to set the name, position, and other general properties of a control. Specific control types may have other properties that are available; the Control object contains the general members available for most controls. The Controls collection and Control object have the following members. Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

Add 1

Cancel

Clear 1

ControlSource

ControlTipText

Count 1

Default

Height

HelpContextID

Item 1

LayoutEffect

Left

Move 2

Name

Object

OldHeight

OldLeft

OldTop

OldWidth

Parent

Remove 1

RowSource

SetFocus

TabIndex

TabStop

Tag

Top

Visible

Width

ZOrder

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.

Start your free trial