Throwback Thursday: April 30, 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

VBA’s Case Changing “Feature”

VBA likes to change the casing of our code (upper/lower/mixed). It may seem random, but it’s not. Read all the details here.

No Longer SetMike Wolfe

PascalCase All the Things

There is only one correct capitalization convention in VBA: PascalCase.

No Longer SetMike Wolfe

How To: Enforce Consistent Letter Casing in VBA

Conquer VBA’s case-changing “feature” once and for all with this simple, brute-force solution: the StandardizeLetterCasing() function.

No Longer SetMike Wolfe

Wisdom from Around the Web

The Case For Case Insensitivity

One of the most pernicious problems with C-based languages is that they’re case-sensitive. While this decision may have made sense in 1972 when the language was created, one wonders why the sins of Kernighan and Ritchie have been blindly perpetuated for the last thirty-three years. I realize this is

Coding HorrorJeff Atwood

Support for clsStandardLetterCasing in the VCS Addin

The approach I described in the third article above is now available out of the box in Adam Waller's VCS Addin (dev version 4.1.5+):

I know we have had a lot of discussion here with various approaches to handling the letter casing challenges with VBA code. While I am not opposed to more sophisticated and elegant approaches, even branching out into other add-ins, I decided to take a more simplistic integrated approach for now. The benefit is that this is built right into the add-in, and works right out of the box without needing to utilize a custom RunBeforeExport hook. It simply checks for the existence of a class module named clsStandardLetterCasing and applies any letter casing rules as described in https://nolongerset.com/standardizelettercasing/

If you prefer to use another approach, or dedicated add-in for this, no problem! The integrated feature doesn't really add any overhead and is simply ignored if you don't have the specially named class in your project. But for those that just need a simple solution that is easy to set up, I think this might be a help. (I know I plan to use it for some projects.)

Cover image generated by Ideogram