VBA Advanced: Class Modules, Events, Ribbon XML, COM Add-ins

VBA Advanced is the seventh volume of the Advanced Excel & Data Modeling series — a production-oriented guide to VBA as software engineering, not macro scripting.

It covers class modules and encapsulation, collection classes, factory functions, worksheet and workbook events, WithEvents listeners, custom RaiseEvent callbacks, and UserForms. Then it moves into the Ribbon — customUI.xml, IRibbonContro...