Page 266 - Excel Progamming Weekend Crash Course

n540629 ch19.qxd 9/2/03 9:35 AM Page 241

Session 19 — Creating Custom Dialog Boxes with User Forms 241

Properties window
View code Project window
View object User form Tool box

Figure 19-1 Elements of the user form designer

A VBA project can contain as many user forms as you want, as long as each
one has a unique name.
Tip

Designing the Interface
Before designing your user form, it helps to have some idea of what the various controls do
and how the finished user form should appear. Controls are covered later in this session, but
the following are the basics of designing a form.

To work with controls that are already on the form, be sure the arrow icon in
the toolbox is selected. The mouse cursor displays as an arrow in this mode.
Tip