Chapter 3
Working in the Visual Basic Editor
In This Chapter
Understanding the Visual Basic Editor
Discovering the Visual Basic Editor parts
Knowing what goes into a VBA module
Understanding three ways to get VBA code into a module
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 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.
