> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: March 13, 2025
- URL: https://nolongerset.com/throwback-thursday-2025-03-13/
- Published: 2025-03-13T23:30:28.000Z
- Updated: 2026-05-08T12:44:25.000Z
- Description: Today's edition of Throwback Thursday is about one of VBA's most underappreciated features: the humble Enum statement.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*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 VideoExcel MVP Paul Kelly packs a bunch of great information (including a well-hidden feature) into this ten-minute video introducing Enums in VBA.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2023/02/Designer--3-.jpeg)](https://nolongerset.com/enums-in-vba-video/)

[Enum Type Naming ConventionThe combination of “IntelliSense overload” and “global identifier case changes” convinced me I needed a different approach.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2020/10/scrabble-15546_1920.jpg)](https://nolongerset.com/enum-type-naming-convention/)

[NEW & IMPROVED: The “Unset” Enum ItemThis hidden feature of VBA lets you take advantage of my “Unset” enum item technique without cluttering up your IntelliSense.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2023/11/Unset-Enum-Item.jpg)](https://nolongerset.com/hiding-the-unset-enum-item/)

[How to Get the String Values of an Enum in VBAGetting the string values for enums in VB.NET is easy using the built-in ToString method. What’s the VBA equivalent?![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2024/06/scribe.jpg)](https://nolongerset.com/enum-tostring/)

[Converting the DataTypeEnum Values to Equivalent VBA TypesTwo simple functions to convert DataTypeEnum values to descriptive strings and their VBA data type counterparts.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/10/detox-1995433_1920.jpg)](https://nolongerset.com/converting-datatypeenum-values/)

## 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,![](https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon.png?v=c78bd457575a)Stack OverflowVityata![](https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon@2.png?v=73d79a89bded)](https://stackoverflow.com/q/41578348/154439)

## Developer Humor

> [mostComfortablePosture](https://www.reddit.com/r/ProgrammerHumor/comments/1jakcbj/mostcomfortableposture/)  
> by [u/YTRKinG](https://www.reddit.com/user/YTRKinG/) in [ProgrammerHumor](https://www.reddit.com/r/ProgrammerHumor/) 

*Cover image generated by Ideogram*