Microsoft® Office Access 2007 VBA

Chapter 2. Using the Visual Basic Editor

IN THIS CHAPTER

First Look at the Visual Basic Editor 11

Explaining VBA Modules 15

Entering and Running Code 16

Getting Help on Code 19

Good Coding Habits 21

First Look at the Visual Basic Editor

The Visual Basic Editor (VBE) is the environment you use to manage your VBA code. The VBE provides tools to enter, test, and organize your code. There are several ways to access the VBE. Pressing Ctrl+G or Alt+F11 opens it. You can also press the Visual Basic button on the Tools Ribbon. Another method is to click the ellipsis next to any event property and choose the Code Builder. In addition, if a code error occurs, you might be presented with a Debug option that also loads the VBE.

This chapter reveals how to ...