Chapter 4. Using the VBA Editor

You'll use the VBA Editor to write almost all of your VBA code. Although you can simply open the VBA Editor and start typing code, knowing a bit about the different components of the editor not only helps you properly structure and debug your code, but saves you time while you're at it. In this chapter, you explore the major structural components of the VBA Editor as well as some basic code debugging techniques.

The topics in Chapters 4 and 5 are so interconnected that it was difficult to decide which chapter to put first. If you get the sense that you are jumping into the middle without having covered the basics, what you think you're missing is likely in Chapter 5.

Get Access™ 2007 VBA Programmer's Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.