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 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 15 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.
Jun 282 min read
Type Library explorer
Have you ever wanted to know what is in a Type Library without having to add a Project Reference to it from your VBA Project?
Jun 272 min read
Add Enum from Type Library
Ever needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...
Articles: Blog2
bottom of page