CHAPTER 2

image

Visual Basic for Applications for Excel, a Refresher

Of course, no advanced book on developing anything in Excel would be complete without a chapter on the interpreter language housed within Excel, Visual Basic for Applications–or better known by its shorthand moniker, VBA.

This chapter won’t be an introduction to VBA but rather a review of VBA programming techniques and development principles found in this book and practiced throughout most of my career. What follows may appear unconventional, at first. Indeed, it may differ somewhat from what you’ve been previously taught. However, I don’t leave you with a few instructions and no guidance. ...

Get Advanced Excel Essentials 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.