Using the Editor Format tab

Figure 7-9 shows the Editor Format tab of the Options dialog box. The options on this tab control the appearance of the VBE itself.

Options

Eik« j Edtofpqimgl Gen«* ftjcfcng colors

MjrnilTiil

A

Se)e:lon T»ict S-ynto* ETOTiUrt

Breeipwtt Tem Comment Text KeywddTert

V

FDie^TOLrxi!

JK«* J JI d.

Endtcattx.

4utn ff

faltD

-

trJ Id' &m isrpte

Fork

Cojtsf fie* (Westefn)

A3CXYiiD3KYI

Mplp

Figure 7-9: The Editor Format tab of the Options dialog box.

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. This 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 these settings.

FONT OPTION

The Font option lets you select the font that's used in your VBA modules. For best results, stick with a fixed-width font (monofont) such as Courier New. In a fixed-width font, all characters are exactly the same width. This makes your code much more readable because the characters are nicely aligned vertically and you can easily distinguish multiple spaces.

SIZE SETTING

The Size setting specifies the size of the font in the VBA modules. This setting is a matter of personal preference determined by your video display resolution and your eyesight. The default size of 10 (points) works for me.

MARGIN INDICATOR BAR OPTION

The Margin Indicator Bar option controls the display of the vertical margin indicator bar in your modules. You should keep this turned on; otherwise, you won't be able to see the helpful graphical indicators when you're debugging your code.

0 0

Post a comment