top of page
Blog posts
Search
Add / remove / re-order parameters ... and update corresponding arguments
VBE_Extras can now help you to add, remove and re-order parameters for a Sub, Function or Property including updating the relevant arguments
Feb 183 min read
Â
Â


Commenting / uncommenting VBA code
There are various ways to comment / uncomment code in VBA ...
Nov 6, 20243 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 5, 20241 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.
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
Â
Â


Articles: Blog2
bottom of page