Chapter 3

Working in the Visual Basic Editor


Bullet Understanding the Visual Basic Editor

Bullet Discovering the Visual Basic Editor parts

Bullet Knowing what goes into a VBA module

Bullet Understanding three ways to get VBA code into a module

Bullet 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?

The Visual Basic Editor (often refered to as the VBE) is a separate application where you write and edit your VBA macros. Beginning with Excel 2013, every workbook displays in a separate window. However, there is only one VBE window, and it works with all open Excel windows.

You can’t run the VBE separately; Excel ...

Get Excel VBA Programming For Dummies, 5th Edition now with O’Reilly online learning.

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