Did you know you can combine lines of code in VBA with the colon character? The key is to understand when--and when not--to use it.

By using the Me keyword, you can leverage the automatically generated properties to retrieve and set data in VBA.

A deep dive into the Empty keyword in VBA: why it exists, how to check for it, when it makes sense to check for it, and--most importantly--how NOT to check for it.

Wondering what the IsMissing() function is all about in VBA? We'll explore that plus all the ins and outs of the VBA keyword that isn't: Missing.

Let's explore the many ways to check for, handle, and store Null values. Spoiler alert: the best way to do it varies between VBA and SQL.

An in-depth look at the Nothing keyword in VBA: when you need it; when you don't; and one technique to avoid it altogether.

Yes, there is a right way and a wrong way to check for empty strings in VBA. Actually, there are *two* right ways and *two* wrong ways. Let's explore all four.

Working with global constants in VBA is unnecessarily difficult, resulting in code that's harder to read and maintain than it needs to be.

VB.NET and VBA may look the same, but there are some important differences. This is a little-known feature of VB.NET that I really wish was available in VBA.

Is VBA an interpreted language? Or a compiled language? Or something in between. Philipp Stiefel shines light on the topic for us.

Overflow errors are usually straightforward. But what about when you get an overflow assigning a value of 1 to a Long integer?