Unleashing the power of Excel with VBA
- By Bill Jelen and Tracy Syrstad
- 4/10/2019
Contents
×
- Barriers to entry
- Barriers to entry
- Knowing your tools: The Developer tab
- Knowing your tools: The Developer tab
- Understanding which file types allow macros
- Understanding which file types allow macros
- Macro security
- Macro security
- Overview of recording, storing, and running a macro
- Overview of recording, storing, and running a macro
- Running a macro
- Running a macro
- Understanding the VB Editor
- Understanding the VB Editor
- Understanding shortcomings of the macro recorder
- Understanding shortcomings of the macro recorder
- Next steps
- Next steps
Next steps
Chapter 2, “This sounds like BASIC, so why doesn’t it look familiar?” examines the three macros you recorded in this chapter to make more sense out of them. When you know how to decode the VBA code, it will feel natural to either correct the recorded code or simply write code from scratch. Hang on through one more chapter. You’ll soon learn that VBA is the solution, and you’ll be writing useful code that works consistently.