Blog posts

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.

Since mid 2022, files containing VBA code received over the internet or via email can be 'blocked' - preventing the VBA code from running.

Fed up with arrays and Collections (and Dictionarys and ArrayLists)? Try List, a better collection for VBA.

Application.OnTime is great if you want to call your procedure to the nearest second. What do you do if you want finer control than that?

Multiple choice UserForm in VBA using a ComboBox - this UserForm allows a user to make a choice when there are more than just Yes/No or OK/C

VBE_Extras includes functions for 'Matches for literal value at cursor' and 'Extract to constant' which are closely related.

Sorting arrays of Objects in VBA - any Objects, Worksheets, Documents, Slides etc or Objects defined by your own custom Class Modules

This is an implementation of the 'merge sort' algorithm - one of the most efficient sorting algorithms. It uses what's known as a 'divide...