top of page
Blog posts
Search
String interpolation
Interpolation means 'inserting one thing into another'. In this case, inserting one (or more) 'sub' Strings into another 'main' String.
Apr 73 min read
0 comments

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.
Oct 2, 202411 min read
0 comments

VBE_Extras: Command Search and Find Setting
Improving 'discoverability' in VBE_Extras with Command Search and Find Setting.
Sep 26, 20242 min read
0 comments


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 24, 20244 min read
0 comments


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 14, 20244 min read
0 comments

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 13, 20245 min read
0 comments

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.
Aug 6, 20244 min read
0 comments


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'.
Jul 17, 202412 min read
0 comments


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"
Jun 12, 20244 min read
0 comments


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
Apr 11, 20244 min read
0 comments


Articles: Blog2
bottom of page