Extra Credit: Getting Ready to Tackle VBA

Ready to start working with VBA? Good. Take a few moments to organize your screen and customize the Visual Basic Editor. That way, you won’t have to hunt and click so much to get going. (To start the Visual Basic Editor, just start your favorite Office program and press Alt+F11.)

The behavior of the Visual Basic Editor is controlled by choosing Tools, Options and clicking the Editor tab. In particular, consider selecting the Require Variable Declaration check box. That will protect you from the single most common source of programming errors—misspellings.