Microsoft Office Tutorials and References
In Depth Information
Customizing the VBE Environment
Auto Data Tips option
If the Auto Data Tips option is set, you can hover your mouse pointer over a variable, and VBE
displays the value of the variable. This technique works only when the procedure is paused while
debugging. When you enter the wonderful world of debugging, you’ll definitely appreciate this
option. I always keep this option turned on.
Auto Indent option
The Auto Indent setting determines whether VBE automatically indents each new line of code by
the same amount as the previous line. I’m a big fan of using indentations in my code, so I keep
this option on. You can also specify the number of characters to indent; the default is four.
Use the Tab key, not the space bar, to indent your code. Using the Tab key results in
more consistent spacing. In addition, you can use Shift+Tab to unindent a line of code.
These keys also work if you select more than one statement.
Drag-and-Drop Text Editing option
The Drag-and-Drop Text Editing option, when enabled, lets you copy and move text by dragging
and dropping. I keep this option turned on, but I never use drag-and-drop editing. I prefer to use
keyboard shortcuts for copying and pasting.
Default to Full Module View option
The Default to Full Module View option specifies how procedures are viewed. If this option is set,
procedures in the code window appear as a single scrollable window. If this option is turned off,
you can see only one procedure at a time. I keep this setting turned on.
Procedure Separator option
When the Procedure Separator option is turned on, the VBE displays separator bars between
procedures in a code window (assuming that the Default to Full Module View option is also selected).
I like the visual cues that show where my procedures end, so I keep this option turned on.
Using the Editor Format tab
Figure 7-10 shows the Editor Format tab of the Options dialog box. The options on this tab
control the appearance of the VBE itself.
h Code Colors option: The Code Colors option lets you set the text color (foreground and
background) and the indicator color displayed for various elements of VBA code.
Choosing these colors is largely a matter of individual preference. Personally, I find the
default colors to be just fine. But for a change of scenery, I occasionally play around with