Blog posts

Nov 63 min read

Commenting / uncommenting VBA code

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

Nov 51 min read

Get a list of the keyboard shortcuts assigned to VBA macros in Excel

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

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.

Sep 262 min read

VBE_Extras: Command Search and Find Setting

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

Sep 244 min read

Comparing VBE_Extras with MZ-Tools

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

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?

Aug 144 min read

Working with the Registry using VBA (the 'wider' Registry: the HKCU, HKCR and HKLM hives)

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

Aug 135 min read

Working with the Registry using VBA (the '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.

Aug 64 min read

Navigating between VBA code and Shapes, Tables and Names in Excel

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.

Articles: Blog2