Throwback Thursday: November 20, 2025
In today's Throwback Thursday, we revisit one of my favorite VBA hacks: a hidden attribute that unlocks IntelliSense when looping through a collection of custom class instances.
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
Strongly Typed Collections in VBA
Get better type safety and access to IntelliSense inside For Each loops by using “strongly-typed collections” in place of the VBA Collection type.
Mike Wolfe
Strongly-Typed Collections: The Easy Way
Creating a strongly-typed collection class in VBA requires jumping through code export-import hoops. What if you didn’t have to, though?
Mike Wolfe
Wisdom from Around the Web
How to Create a Strongly typed Collection in Vba
An Excel File with the sample code can be found here In this blog post I will show you how to create a Strongly Type Collection Class wich…
Posted by
Pierpaolo
Developer Humor
ifItWorksDontTouchIt
by u/Same_Fruit_4574 in ProgrammerHumor
Cover image generated by Ideogram
