Blog posts

There are various ways to comment / uncomment code in VBA ...

The solution is to use the 'Keyboard shortcuts in this Project' function of VBE_Extras which you identify all such keyboard shortcuts.

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

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

Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.

The functionality of the two tools complements each other - and VBA developers are missing out if they don't have both tools!

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

This post concerns working with the Registry outside of the "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" key.

This post concerns working with the the "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" key within the Registry.

How to navigate directly between a Shape, Table or Name in the Excel user-interface and references of that Shape, Table or Name in VBA code.