Throwback Thursday: May 1, 2025
In this week's edition of Throwback Thursday, we explore the magic of "self-healing" object variables and caching in VBA.
With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
Caching Object Instances in VBA Classes
Simplify the object initialization code in your class modules without sacrificing performance using this easy technique.
Mike Wolfe
VBA Performance Tip: How to Cache Results of Slow Processes
Store expensive function call results with memoization. Learn to implement this technique with our step-by-step instructions and sample code.
Mike Wolfe
Use Caching to Speed Up Editable Forms with Hidden Duplicate Values
In this installment, we reduce our database calls by more than 80% by shifting the bulk of the work to high-performing VBA dictionary structures.
Mike Wolfe
Invalidating the Cache on the Hidden Duplicate Values Form
In this installment, we demonstrate how simple it is to refresh the cache when you use self-healing object variables.
Mike Wolfe
Wisdom from Around the Web
Self-Healing Objects, by Ben Clothier
Self-Healing Object Variables | DEVelopers HUT
Exploring how we can replace traditional CreateObject calls with Self-Healing variables to improve overall application performance and simplify code.
Developer Humor
Two Hard Problems
There are 2 hard problems in computer science: cache invalidation, naming things, and off-by-1 errors.
- Leon Bambrick
Source: Two Hard Things, by Martin Fowler
Cover image generated by Ideogram
