top of page
Blog posts
Search
Nov 6, 20243 min read
Commenting / uncommenting VBA code
There are various ways to comment / uncomment code in VBA ...
0 comments


Nov 5, 20241 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.
0 comments


Nov 4, 20243 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.
0 comments


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


Sep 24, 20244 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!
0 comments

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


Aug 6, 20244 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.
0 comments


Jul 1, 20245 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.
0 comments


Jun 28, 20242 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?
0 comments


Jun 27, 20242 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 ...
0 comments


Articles: Blog2
bottom of page