The main purpose of this Book is to help you learn the basics of working with the Visual Basic Editor (VBE).
This Book: (i) Is part of my Excel Macros for Beginners Series; and (ii) Assumes you know about the topics covered in the previous Books in the Series, particularly in Create Excel Macros Without Programming.
This Book has two main goals:
#1. Help you learn the basics of working with the Visual Basic Editor (VBE). For these purposes, this Book introduces and explains (among others): (i) The VBE and its main characteristics/components/sections; and (ii) How to use the VBE to carry out the most common activities/operations you (an Excel macro/VBA beginner) are likely to require for achieving your objectives.
#2. Introduce several useful tools, features and customizations you (an Excel macro/VBA beginner) may find helpful.
This Book does not cover every single detail of working with the Visual Basic Editor (VBE). It focuses on the information, details and processes that (in my opinion) are helpful to an Excel macro/VBA beginner.
This Book is divided in nine Chapters.
#1. Chapter 1 is an introduction to the Visual Basic Editor (VBE).
#2. In Chapter 2, you learn how to access the VBE, including how to: (i) Open the VBE; and (ii) Toggle between Excel and the VBE.
#3. In Chapter 3, you learn how to work with one of the most commonly-used VBE windows: The Project Explorer or Project Window.
#4. In Chapter 4, you learn how to work with modules. As you learn in this Chapter, you can usually think of modules as containers of VBA code.
#5. In Chapter 5, you learn how to work with another (in addition to the Project Explorer) of the most commonly-used VBE windows: The Code Window.
#6. Chapter 6 is an introduction to working with VBA code in the VBE. This Chapter focuses on the perspective of Excel macro beginners who usually create macros by working with the Macro Recorder.
#7. Chapter 7 is an introduction to: (i) VBE customization; and (ii) VBE window behavior. This includes step-by-step explanations of the processes you can use to specify/modify the behavior of the windows in the VBE.
#8. In Chapter 8, you learn how to work with two tools/features that help you while creating macros: (i) The Interpreter; and (ii) Auto Syntax Check.
#9. In Chapter 9, you learn how to modify (to a certain extent) the appearance of: (i) The VBE; and (ii) The VBA code you work with.