Page 72 - Microsoft Office Excel 2003 Programming Inside Out

Microsoft Office Excel 2003 Programming Inside Out

The Format Menu
The Format menu contains commands to assist with the placement and formatting of objects
on user forms. Table 4-3 lists the items available on the Format menu.

Table 4-3. Menu Items Available on the Format Menu in the Visual Basic Editor
Item Description
Align€ Displays the Align submenu, which lets you line up two or more
objects along a common border
Make Same Size€ Displays the Make Same Size submenu, which lets you make two or
more objects the same size in width, in height, or both
Size to Fit Resizes an object’s height and width so that its contents fit exactly
Size to Grid€ Resizes an object’s height and width so that its borders rest upon
the nearest grid lines shown on the user form
Horizontal Spacing€ Displays the Horizontal Spacing submenu, which lets you adjust the
horizontal spacing among two or more objects
Vertical Spacing€ Displays the Vertical Spacing submenu, which allows you to adjust
the vertical spacing among two or more objects
Center in Form€ Displays the Center in Form submenu, which lets you center an
object either horizontally or vertically on a form
Arrange Buttons€ Displays the Arrange Buttons submenu, which allows you to arrange
button objects evenly along the bottom or right side of the user form.
Group€ Creates a group out of selected objects so that they can be
manipulated together
Ungroup Removes the grouping of objects
Order€ Displays the Order submenu, which lets you rearrange the order in
Chapter 4
which objects are layered on the user form

The Debug Menu
The Debug menu provides several tools to assist with debugging (testing) the execution of
procedures. Table 4-4 lists the items available on the Debug menu.

46
Part 2: Visual Basic for Applications