Blog posts

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

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

When developing code in any modern IDE (integrated development environment), you will always find that your cursor (caret) location is track

VBE_Extras can now automatically implement and extract Interfaces for you. Both these functions are in the Refactor sub-menu.

What's the point of adding line numbers to VBA code? Only one good reason in my opinion … error handling.

Indenting code ... it's not sexy ... but it does make code much more readable and maintainable when done correctly