Unleashing the power of Excel with VBA

By Bill Jelen and Tracy Syrstad
4/10/2019

Contents

Barriers to entry
Knowing your tools: The Developer tab
Understanding which file types allow macros
Macro security
Overview of recording, storing, and running a macro
Running a macro
Understanding the VB Editor
Understanding shortcomings of the macro recorder
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.

Save to your account