Blog posts

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?

In any modern code development tool, you can highlight all on-screen references of a code member. With VBE_Extras, so does the VBE!

Using the Mandelbrot Set to demonstrate the relative speed of using C# code via COM Interop from VBA.