Blog posts

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 ...

If you develop your VBA code using early binding but switch to late binding when deploying, then 'special binding' may be useful to you.

Show All Members is a larger, searchable, filterable equivalent that also shows, where available, the 'doc string' for members.

Turn back the clock and revert to an earlier version of your code or just view changes that have been made since an earlier point in time.

... is a pain with VBA when developing and running code from within the VBE ... so make life simpler with "Sub To Run" and "Run Again"

Have a module without "Option Explicit" and need to add it? Don't do it manually, use VBE_Extras to do it for you ...