top of page
Blog posts
Search
Filter a ListBox using a TextBox
Show a UserForm with a ListBox which can be filtered by typing one or more characters into a TextBox.
Feb 243 min read
0 comments


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
0 comments


Commenting / uncommenting VBA code
There are various ways to comment / uncomment code in VBA ...
Nov 6, 20243 min read
0 comments


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
0 comments


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
0 comments


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
0 comments


VBE_Extras: Command Search and Find Setting
Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.
Sep 26, 20242 min read
0 comments


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
0 comments


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
0 comments


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
0 comments


Articles: Blog2
bottom of page