Chapter 3

Working in the Visual Basic Editor

In This Chapter

arrow Understanding the Visual Basic Editor

arrow Discovering the Visual Basic Editor parts

arrow Knowing what goes into a VBA module

arrow Understanding three ways to get VBA code into a module

arrow Customizing the VBA environment

As a more experienced-than-average Excel user, you probably know a good deal about workbooks, formulas, charts, and other Excel goodies. Now it’s time to expand your horizons and explore an entirely new aspect of Excel: the Visual Basic Editor. In this chapter, you find out how to work with the Visual Basic Editor, and you get down to the nitty-gritty of writing some VBA code.

What Is the Visual Basic Editor?

I'm going to save some wear and tear on my fingers and refer to the Visual Basic Editor as the VBE. The VBE is a separate application where you write and edit your VBA macros. It works seamlessly with Excel. By seamlessly, I mean that Excel takes care of opening the VBE when you need it.

Beginning with Excel 2013, every ...

Get Excel VBA Programming For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.