Set the preferences for a Visual Basic project

Which Office program are you using?

Word

PowerPoint

Excel

Word

  1. On the Word menu, click Preferences.

  2. To automatically verify correct syntax after you enter a line of code, click the Editor tab, and then under Code Settings, select the Auto Syntax Check check box.

  3. To require explicit variable declarations in modules, click the Editor tab, and then under Code Settings, select the Require Variable Declaration check box.

  4. To allow you to tab to the first line of code and set where all subsequent lines of code will start, click the Editor tab, and then under Code Settings, select the Auto Indent check box.

  5. To set the tab width, click the Editor tab, and then under Code Settings in the Tab Width box, enter the width that you want.

    The tab widths range from 1 to 32 spaces, and the default is 4 spaces.

  6. To display procedures in the Code window as a single scrollable list, click the Editor tab, and then under Window Settings, select the Default to Full Module View check box.

  7. To display separator bars at the end of each procedure, click the Editor tab, and then under Window Settings, select the Procedure Separator check box.

  8. To change the fonts and colors of your code, click the Editor Format tab, and then make the changes that you want.

  9. To set the general, error handling, and compile settings for a Visual Basic project, click the General tab, and then make the changes that you want.

PowerPoint

  1. On the PowerPoint menu, click Preferences.

  2. To automatically verify correct syntax after you enter a line of code, click the Editor tab, and then under Code Settings, select the Auto Syntax Check check box.

  3. To require explicit variable declarations in modules, click the Editor tab, and then under Code Settings, select the Require Variable Declaration check box.

  4. To allow you to tab to the first line of code and set where all subsequent lines of code will start, click the Editor tab, and then under Code Settings, select the Auto Indent check box.

  5. To set the tab width, click the Editor tab, and then under Code Settings in the Tab Width box, enter the width that you want.

    The tab widths range from 1 to 32 spaces, and the default is 4 spaces.

  6. To display procedures in the Code window as a single scrollable list, click the Editor tab, and then under Window Settings, select the Default to Full Module View check box.

  7. To display separator bars at the end of each procedure, click the Editor tab, and then under Window Settings, select the Procedure Separator check box.

  8. To change the fonts and colors of your code, click the Editor Format tab, and then make the changes that you want.

  9. To set the general, error handling, and compile settings for a Visual Basic project, click the General tab, and then make the changes that you want.

Excel

  1. On the Excel menu, click Preferences.

  2. To automatically verify correct syntax after you enter a line of code, click the Editor tab, and then under Code Settings, select the Auto Syntax Check check box.

  3. To require explicit variable declarations in modules, click the Editor tab, and then under Code Settings, select the Require Variable Declaration check box.

  4. To allow you to tab to the first line of code and set where all subsequent lines of code will start, click the Editor tab, and then under Code Settings, select the Auto Indent check box.

  5. To set the tab width, click the Editor tab, and then under Code Settings in the Tab Width box, enter the width that you want.

    The tab widths range from 1 to 32 spaces, and the default is 4 spaces.

  6. To display procedures in the Code window as a single scrollable list, click the Editor tab, and then under Window Settings, select the Default to Full Module View check box.

  7. To display separator bars at the end of each procedure, click the Editor tab, and then under Window Settings, select the Procedure Separator check box.

  8. To change the fonts and colors of your code, click the Editor Format tab, and then make the changes that you want.

  9. To set the general, error handling, and compile settings for a Visual Basic project, click the General tab, and then make the changes that you want.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×