Page 428 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out

Common Properties, Methods, and Events
Because UserForm controls are objects like the other objects you have already seen, they have
a rich collection of properties, methods, and events. Table 19-2 contains a list of the key prop­
erties, methods, and events that are common to many of the form controls.
Chapter 19
Table 19-2. Key Properties, Methods, and Events of the UserForm Controls
Property/Method Description
BackColor Property: controls the color of the background of the control.
Caption Property: contains text that’s displayed on the control, but can’t
be changed by the user.
Change Event: called when the Value property changes.
Click Event: called when the user clicks the control using the mouse.
ControlTipText Property: contains text that is displayed when the user hovers the
mouse pointer over the control for a moment.
DblClick Event: called when the user double-clicks the control with the mouse.
Enabled Property: when True, means that the control can receive the focus
and will respond to user input.
Enter Event: called just before the control receives the focus from
another control on the same form.
Exit Event: called just before the control loses the focus to another
control on the same form.
Font Property: contains an object reference to a Font object, which
defines the characteristics of the text displayed on the control.
ForeColor Property: contains the color used to draw the foreground of the
control.
Height Property: contains the height of the control in points.
Left Property: contains the distance between the left edge of the
control and the left edge of the form on which the control resides.
Locked Property: when True, the user is not permitted to change the value
of the control.
Name Property: contains the name of the control.
SpecialEffect Property: specifies how the control is drawn.
TabIndex Property: specifies the control’s relative position in the tab
sequence.
TabStop Property: when True, means that the control will accept the focus
when the user tabs to it.
Top Property: contains the distance between the top edge of the
control and the top edge of the form on which the control resides.
Value Property: describes the state or content of a control.

402