Using The Visual Basic Editor

Kxl

ra

OPTION

FUNCTION

Auto Syntax Check

Allows the VBE to check the syntax of each line of code after you type it.

Require Variable Declaration

Requires explicit variable declarations within all modules by adding the option Explicit statement to the top of all new modules that you create. See Chapter 3 for information on variable declaration.

Auto List Member

Reminds you of the next logical value for completing the current statement. As you type your code, a list displays based upon the current insertion point.

Auto Quick Info

Displays information about functions and their parameters as you type.

Auto Data Tips

For debugging code: The current value of the variable displays when you place your cursor over the variable while in Break mode. See Chapter 8 for more information about debugging your VBA code.

Auto Indent

This option tabs to the first line of code. After you set a tab location, all following lines start at the same tab location. You specify the width of the tabs in the Tab Width field. You can make a tab between 1 and 32 spaces wide.

■ The settings display in the Sample box.

■ The text in the Code window changes to reflect your modifications.

■ You can make modifications to additional font settings by repeating steps 1 through 8.

—0 Click theQand click the color you want to use as the font color.

—Q Click the0 and click a background color option.

■ The settings display in the Sample box.

LQ Click OK to close the Options dialog box.

■ The text in the Code window changes to reflect your modifications.

■ You can make modifications to additional font settings by repeating steps 1 through 8.

0 0

Post a comment