Blog posts

Calling the members of a dynamic-link library (DLL, in a .dll file), from VBA code, without having to first (separately) register that DLL.

Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.

Have you ever been in the situation where you have two versions of a Module and need to identify the differences?

This post concerns working with the Registry outside of the "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" key.

This post concerns working with the the "HKEY_CURRENT_USER\Software\VB and VBA Program Settings" key within the Registry.

How to navigate directly between a Shape, Table or Name in the Excel user-interface and references of that Shape, Table or Name in VBA code.

It is possible to write VBA code that will function on other VBA code. This is called 'extensibility'.

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

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

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