Throwback Thursday

Throwback Thursday: April 2, 2026

In today's edition of Throwback Thursday, we revisit some of the problems with global constants in VBA and my preferred alternative.

Mike Wolfe

• 2 min read
Throwback Thursday: April 2, 2026

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

Five Problems Working with Global Constants in VBA
Working with global constants in VBA is unnecessarily difficult, resulting in code that’s harder to read and maintain than it needs to be.
No Longer SetMike Wolfe
“Hiding” Global Data in VBA
How to implement Steve McConnell’s sage advice for handling global data, with techniques for both global constants and global variables.
No Longer SetMike Wolfe
Better Global Constants in VBA with Dot-Driven Development
My global constant “C” class--with PredeclaredId = True--is a great alternative to traditionally-declared global Public Const’s.
No Longer SetMike Wolfe

Developer Humor

Cover image generated by Ideogram

Never miss an article.

Sign up to receive a Sunday morning email with links and recaps of the seven articles published that week.
(I'll never sell your email. Unsubscribe any time.)


All original code samples by Mike Wolfe are licensed under CC BY 4.0