Page 300 - Excel Progamming Weekend Crash Course

r540629 ch21.qxd 9/2/03 9:35 AM Page 275

Session 21 — Advanced User Form Techniques 275

When you select multiple controls, the first control selected displays white handles while
the other selected controls display black handles. This is shown in Figure 21-2. The white
handles mark the guide control — the one used as the reference for the formatting com-
mands. For example, if you are using a command to align controls, they will be aligned at
the position of the guide control.

Figure 21-2 When multiple controls are selected, the guide control
has white handles.

When multiple controls are selected, click anywhere on the form to deselect
them.
Tip
Multiple selected controls can be moved as a group by dragging and can also be deleted
as a group by pressing Delete. More useful, however, are the commands found on the Format
menu. These commands are described in Table 21-2.

Table 21-2 Format Menu Commands

Command Action
Align ➪ Lefts, Centers, or Rights Aligns the left edge, center, or right edge of
selected controls to the horizontal position of
the guide control
Align ➪ Tops, Middles, or Bottom Aligns the top edge, middle, or bottom edge of
selected controls to the vertical position of the
guide control

Align ➪ To Grid Aligns the position and sizes of controls to the
current form grid

Make Same Size➪Width, Height, or Both Sizes the controls to match the guide control
Horizontal Spacing ➪ Make Equal Equalizes the horizontal space between selected
controls

Continued