Microsoft Office Tutorials and References
In Depth Information
Once you’ve selected the form, you can adjust its size by dragging its borders. Move the
mouse pointer over one of the squares on the border, and the mouse pointer will change to a
double arrow. Click and hold the mouse button while moving the mouse to adjust the size of
You can also adjust the form’s size in the Properties window. The height of the form is
controlled by the Height property, and its width is controlled by the Width property. These values
are measured in points.
Properties of a UserForm
The UserForm contains a wide range of properties that control how it looks and works. Table
19-1 lists some of the key properties.
Table 19-1. Key Properties of the UserForm Object
Contains the color of the background of the form.
Contains the value displayed in the form’s title.
When True , means that the form is available for use.
Specifies the height of the form in points.
Specifies the distance between the left edge of the form and
the left edge of the screen.
Contains the name of the form.
Displays the specified picture as the background of the form.
Specifies which scroll bars appear on the form. Can be:
fmScrollBarsNone , fmScrollBarsHorizontal , fmScrollBarsVertical ,
or fmScrollBarsBoth .
Determines where the form is displayed on the screen. A value
of 0 means that the Top and Left properties are used to position
the form. A value of 1 means that the form will be displayed on
the center of the Excel application. A value of 2 means that the
form will be displayed in the center of the screen. A value of 3
means that the form will be displayed in the upper-left corner of
Specifies the distance between the top of the form and the top
edge of the screen.
Specifies the width of the form in points.
The Name property contains the name of the user form. Remember that this property actu
ally appears at the top of the list of properties rather than in alphabetical order like the rest of
the properties are listed.