VBA - No Longer Set

Diving Deeper into the World of Fluent APIs: An Unusual Way of Constructing Class Modules

Martin Fowler first coined the term fluent interfaces back in 2005. What are they, what do you need to know about them, and what do they look like in VBA?

VBA

Dollar Signs at the End of VBA Functions

What's the difference between Left() and Left$()? Why would you use one or the other? And what do *I* do, personally?

Tools

Checking Version Compatibility with NetOffice

Take advantage of the open-source NetOffice project on GitHub to look up version compatibility for the Access/Office/Word/Excel object models.

Code Library

SetPredeclaredId(): Change the Hidden PredeclaredId Attribute of a VBA Class Module

This simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.

VBA

3 Ways to Generate Temporary File Names in VBA

Here are three options for generating temporary file names in VBA. Which is best? As with many programming questions, the answer is, "It depends."

TempVars

A Safer Way to Use TempVars

The TempVars object is an intriguing alternative to traditional global variables, but it has some shortcomings. Here's one way to work around them.

VBA

Namespaces in VBA

VBA may not have the same level of formal support for namespaces as VB.NET, but with a little creativity, we can realize the same benefits in other ways.

Quick Tip

Quick Tip: Set Next Statement with Mouse

Try this tip the next time you use the Edit & Continue feature when debugging. After more than 15 years of developing VBA, I'm still learning new things.

VBA

Static Functions and Subs

After fifteen years of writing VBA, I'm still learning new features of the language. Even if they're not particularly useful features...

Hidden Features

How to Show Hidden Items in the VBA Object Browser

One possible fix for the "Cannot jump to '|' because it is hidden" error is to show hidden members in the VBA object browser.

Memory Management

Memory Management in VBA: 3 Keys to Avoiding Memory Leaks

Managing memory in VBA is a piece of cake, especially if you follow three simple guidelines.

VBA

Philipp Stiefel on VBA Compilation

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

VBA

Avoiding Overflow Errors When Defining Calculated Constants

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

Fluent API

Fluent Interfaces

It's probably irresponsible of me to share the following technique with you because you'll be so tempted to abuse it. But let's do it anyway.