Turn Syntax Checking On or Off

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

Visual Basic includes a syntax-checking feature that:

  • Checks each statement as you enter it for syntax errors, such as a misspelled keyword or missing separator, and alerts you if there are errors.

  • Translates the code to an internal form if the syntax is correct, which speeds the transition to run time.

This feature is turned on when you first start, but you can turn it off if you prefer to write code without being alerted to errors as they occur.

To enable syntax checking

  1. On the Tools menu, click Options.

  2. Select the Editor tab.

  3. Select the Auto Syntax Check check box.

  4. Click OK.

To disable syntax checking

  1. Click Options on the Tools menu.

  2. Select the Editor tab.

  3. Clear the Auto Syntax Check check box.

  4. Click OK.

Show:
© 2014 Microsoft