Blog posts

Nov 43 min read

Call Hierarchy for a VBA procedure

A Call Hierarchy shows calls of a given procedure by other procedures, and calls from that same given procedure to other procedures.

Oct 211 min read

Dynamically loading a DLL "on-the-fly"

Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.

Aug 244 min read

Compare VBA Modules

Have you ever been in the situation where you have two versions of a Module and need to identify the differences?

Jun 282 min read

Type Library explorer

Have you ever wanted to know what is in a Type Library without having to add a Project Reference to it from your VBA Project?

Jun 272 min read

Add Enum from Type Library

Ever needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...

Jun 264 min read

Special binding

If you develop your VBA code using early binding but switch to late binding when deploying, then 'special binding' may be useful to you.

Jun 255 min read

Improving the VBE's Intellisense 'auto list members' popup

Show All Members is a larger, searchable, filterable equivalent that also shows, where available, the 'doc string' for members.

May 175 min read

Adding / updating "Project References" in the VBE

A better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)

Feb 24, 202323 min read

Calling C# code from VBA (COM interop)

Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...

Articles: Blog2