Commenting / uncommenting VBA code
There are various ways to comment / uncomment code in VBA ...
top of page
Blog posts
Search
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.
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.
Jul 1712 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'.
Articles: Blog2
bottom of page