Blog posts

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

Jul 17, 202412 min read

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

Jul 1, 20245 min read

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 28, 20242 min read

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

Jun 27, 20242 min read

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

Jun 26, 20244 min read

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

Jun 25, 20245 min read

A better way to add, update and explore the available "Project References" (Type Libraries and other VBA Projects)

May 17, 20245 min read

Articles: Blog2