Blog posts

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

How to add Ribbon controls (a button and a ComboBox in this post) to an AddIn

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

How to create an Excel AddIn and use it to listen Excel application events using VBA code.

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.

Working with files and folders from VBA code can be a hassle - here's my standard procedures to make working with files and folders simpler

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

With VBE_Extras, you can go into full screen with one click. And back. As many times as you want.

It's fairly straight-forward to get the basic properties for a file, but how do you get the extended properties for a file with VBA?