Page 77 - Microsoft Office Excel 2003 Programming Inside Out

VBA Programming Starter Kit

The second set of options, Window Settings, controls how the Code window displays multi­
ple procedures and determines how you may move code using the mouse. By enabling the
Drag-and-Drop-Text option, you can drag and drop elements within the current code and
from the Code window to and from the Immediate and/or Watch windows. Turning on the
Default to Full Module View sets the view for new module windows to either a scrollable
window or a single procedure view, while turning on the Procedure Separator option will
draw a line separating procedures.
The controls on the Editor Format tab of the Options dialog box, shown in Figure 4-6, let you
control the font style that is used to display code. From the color of different code elements
(keywords, comments, syntax errors, selected elements, and so on) to the typeface and the
size of the font, the code window can be customized to fit your particular needs. You can also
turn the Margin Indicator Bar on and off, though you should probably leave it on because it
provides a quick way to turn Break Points on and off.

Chapter 4

Figure 4-6. The Editor Format tab lets you determine everything from the font in which your
code is displayed to the text color used to highlight important program elements.

Inside Out

The General tab, shown in Figure 4-7, provides options for Form Grid Settings, the display
of ToolTips, the automatic closing of Form and Module windows, warning before variables
are reset, error trapping, and determining when code is compiled. The Form Grid Settings
allow you turn the grid dots on and off when designing user forms; you can also change the
horizontal and vertical distance between grid dots and opt to have new controls aligned to
the grid as they are added. You can also turn the ToolTips that help explain what each but-
ton on a toolbar does on and off.

51
Part 2: Visual Basic for Applications