Blog posts

Compare VBA Modules

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

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.

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.

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.

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

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.

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?

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

Special binding

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

Improving the VBE's Intellisense 'auto list members' popup

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

Articles: Blog2