Microsoft Office Tutorials and References
In Depth Information
Figure 19-1. A UserForm object allows a VBA programmer to design a graphical interface to
Designing a UserForm
Designing a UserForm involves selecting controls from the Toolbox and dragging them onto
the drawing surface. Once they are on the form, you modify how they look by selecting the
control and then working with it graphically or by going to the Properties window and mod
ifying the control’s properties.
To walk through a simple example of how this process works, just follow these steps:
Create a new UserForm by choosing Insert, UserForm from the Visual Basic Editor’s
Move the mouse pointer over the Label control in the toolbox.
Click and hold the mouse button down.
Move the mouse pointer onto the drawing surface and release the mouse button.
This will add the Label control to the form.