top of page
Blog posts
Search
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.
Nov 4, 20243 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.
Oct 2, 202410 min read


VBE_Extras: Command Search and Find Setting
Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.
Sep 26, 20242 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!
Sep 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?
Aug 24, 20244 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 14, 20244 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 13, 20245 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.
Aug 6, 20244 min read


VBA extensibility – using VBA to add new functionality to the VBE
It is possible to write VBA code that will function on other VBA code. This is called 'extensibility'.
Jul 17, 202412 min read


Add a "GetEnumAsString()" Function
Get the name of an Enum member, not its value using the 'Add a "GetEnumAsString()" function' ... automatically added by VBE_Extras.
Jul 1, 20245 min read


Articles: Blog2
bottom of page