Chapter 2
Getting Cozy with Visual Basic Editor
In This Chapter
Understanding Visual Basic Editor components
Working with the project window
Using the code window
Customizing Visual Basic Editor
Visual Basic Editor (VBE) is the environment where all Excel macros are stored and processed. Each workbook you create comes with this interconnected VBE environment free of charge. Even if you never record one macro, VBE is in the background waiting to be used. When you create a macro, VBE quietly comes to life ready to process the various procedures and routines you give it.
In this chapter, you take your first look behind the curtain to explore Visual Basic Editor.
Working in Visual Basic Editor
Visual Basic Editor is a separate application that runs when you open Excel. To see this hidden VBE environment, you’ll need to activate it. The quickest way to activate VBE is to press Alt+F11 when Excel is active. To return to Excel, press Alt+F11 again.
You can activate VBE also by using the Visual Basic command, which is on Excel’s Developer tab.
Understanding VBE components
Get Excel Macros 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.
