top of page
Blog posts
Search
Unblock a file containing VBA code
Since mid 2022, files containing VBA code received over the internet or via email can be 'blocked' - preventing the VBA code from running.
Sep 15, 20231 min read
0 comments

How do YOU clear the Immediate window in the VBE?
Want a better way to clear or scroll to the end of the Immediate window ... manually or automatically when you run code ... read this!
Aug 10, 20232 min read
0 comments

Custom colours in the VBE
Get fed up with the boring default colours available in the VBE's 'Options' dialog? Don't like cyan text on a magenta background ... make...
Mar 22, 20231 min read
0 comments

Calling C# code from VBA (COM interop)
Update October 2024: This post uses Visual Studio and/or RegAsm to 'statically' register your C# library before it is loaded and used by...
Feb 24, 202323 min read
11 comments

What is VBA
What is VBA VBA stands for Visual Basic for Applications. VBA is Microsoft’s programming language for a number of the Office suite of...
Feb 22, 20225 min read
2 comments

Website is live!
Finally did it, after 20+ years working in industry and nearly 18 months of freelancing on Upwork, this website is live! Ready to...
Feb 22, 20221 min read
1 comment

Articles: Blog2
bottom of page