Page 422 - Microsoft Office Excel 2003 Programming Inside Out

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

Chapter 19

Figure 19-1. A UserForm object allows a VBA programmer to design a graphical interface to
his application.

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:
1 Create a new UserForm by choosing Insert, UserForm from the Visual Basic Editor’s
main menu.
2 Move the mouse pointer over the Label control in the toolbox.
3 Click and hold the mouse button down.
4 Move the mouse pointer onto the drawing surface and release the mouse button.
This will add the Label control to the form.

396