Page 301 - Excel Progamming Weekend Crash Course

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

276 Sunday Morning

Table 21-2 Continued

Command Action
Horizontal Spacing➪Increase or Decrease Increases or decreases the horizontal space
between selected controls

Horizontal Spacing ➪ Remove Removes horizontal space between selected
controls

Vertical Spacing ➪ Make Equal Equalizes the vertical space between selected
controls

Vertical Spacing ➪ Increase or Decrease Increases or decreases the vertical space between
selected controls
Vertical Spacing ➪ Remove Removes vertical space between selected controls

Center in Form➪Horizontally or Vertically Centers the control(s) in the form either hori-
zontally or vertically

Arrange Buttons ➪ Bottom Arranges selected CommandButton controls along
the bottom of the form
Arrange Buttons ➪ Right Arranges selected CommandButton controls along
the right edge of the form

The following exercise shows you how you might use some of these commands. It is not
a real project, but it does use a user form to demonstrate some of these design commands.
1. Select Insert ➪ UserForm to add a new user form to a project.
2. Add the following controls to the form: four CheckBox controls, one TextBox con-
trol, one Label control, and two CommandButton controls. Your form should look
something like Figure 21-3. Do not be concerned with control captions and other
properties.

Figure 21-3 The form before arranging the controls