Blog posts

Oct 211 min read

Dynamically loading a DLL "on-the-fly"

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

Sep 262 min read

VBE_Extras: Command Search and Find Setting

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

Aug 244 min read

Compare VBA Modules

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

Aug 144 min read

Working with the Registry using VBA (the 'wider' Registry: the HKCU, HKCR and HKLM hives)

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

Aug 135 min read

Working with the Registry using VBA (the '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.

Aug 64 min read

Navigating between VBA code and Shapes, Tables and Names in Excel

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.

Jul 1712 min read

VBA extensibility – using VBA to add new functionality to the VBE

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

Jun 124 min read

Running code in one place when you're editing code in another ...

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

Apr 114 min read

Working with files and folders in VBA

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

Sep 21, 20231 min read

Mandelbrot Set viewer - VBA vs C#

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

Articles: Blog2