top of page
Blog posts
Search
Nov 4, 20243 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.
0 comments


Oct 2, 202411 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.
0 comments

Aug 24, 20244 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?
0 comments


Jun 28, 20242 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?
0 comments


Jun 27, 20242 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 ...
0 comments


Jun 26, 20244 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.
0 comments


Jun 25, 20245 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.
0 comments


May 17, 20245 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)
0 comments

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...
11 comments

Articles: Blog2
bottom of page