Throwback Thursday: March 13, 2025
Today's edition of Throwback Thursday is about one of VBA's most underappreciated features: the humble Enum statement.
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
Enums in VBA: A Great 10-Minute Introductory Video
Excel MVP Paul Kelly packs a bunch of great information (including a well-hidden feature) into this ten-minute video introducing Enums in VBA.
Mike Wolfe
Enum Type Naming Convention
The combination of “IntelliSense overload” and “global identifier case changes” convinced me I needed a different approach.
Mike Wolfe
NEW & IMPROVED: The “Unset” Enum Item
This hidden feature of VBA lets you take advantage of my “Unset” enum item technique without cluttering up your IntelliSense.
Mike Wolfe
How to Get the String Values of an Enum in VBA
Getting the string values for enums in VB.NET is easy using the built-in ToString method. What’s the VBA equivalent?
Mike Wolfe
Converting the DataTypeEnum Values to Equivalent VBA Types
Two simple functions to convert DataTypeEnum values to descriptive strings and their VBA data type counterparts.
Mike Wolfe
Wisdom from Around the Web
Is there a way to get the enums in VBA?
Is there a way to get the enums in VBA? Something like this example for C#, but for VBA? using System; class EnumsExampleZ
{ private enum SiteNames { SomeSample = 1,
Vityata
Developer Humor
mostComfortablePosture
by u/YTRKinG in ProgrammerHumor
Cover image generated by Ideogram
