Blog posts

There are various ways to comment / uncomment code in VBA ...

The solution is to use the 'Keyboard shortcuts in this Project' function of VBE_Extras which you identify all such keyboard shortcuts.

A Call Hierarchy shows calls of a given procedure by other procedures, and calls from that same given procedure to other procedures.

Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.

The functionality of the two tools complements each other - and VBA developers are missing out if they don't have both tools!

Have you ever been in the situation where you have two versions of a Module and need to identify the differences?

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.

Get the name of an Enum member, not its value using the 'Add a "GetEnumAsString()" function' ... automatically added by VBE_Extras.

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?

Ever needed to convert an Enum member's name to its value when changing from early to late binding? Read this ...