Throwback Thursday: August 28, 2025
In today's edition of Throwback Thursday, we explore three different ways to determine the type of a variable 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
TypeName vs. TypeOf
You can check the type of a variable in VBA using TypeName or TypeOf. But do you know when to use which? And why? Let’s explore.
Mike Wolfe
VarType in VBA
The VarType function lets you determine the underlying type of a variable. How does it fit in with TypeName and TypeOf?
Mike Wolfe
Wisdom from Around the Web
Determine Object Type
Is there a way to determine the Object type, when passing a reference to a function? I’m using a security permissions function, which determines if the user has permission to view/edit the Form pa…
maxhugen
Developer Humor
haYoureAbsolutelyRight
by u/precinct209 in ProgrammerHumor
Cover image generated by Ideogram
