Chapter 3
Working in the Visual Basic Editor
IN THIS CHAPTER
Accessing the Visual Basic Editor
Discovering the Visual Basic Editor parts
Knowing what goes into a VBA module
Getting VBA code into a module
Customizing the VBA environment
The Visual Basic Editor (VBE) is the main tool for programming in VBA. It’s where you view and edit recorded code and write code from scratch. In this chapter, you find out how to work with the VBE, and you get down to the nitty-gritty of writing some VBA code.
Getting to Know the Visual Basic Editor
The Visual Basic Editor (often referred to as the VBE) is a separate application where you write and edit your VBA macros. When you open multiple workbooks in Excel, each opens in a separate window. However, the VBE only ever has one window, and from this window you can write, edit, and view macros for any open workbook.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
You can’t run the VBE separately; ...