The VBA Multithreading Tool, from AnalystCave.com, is a free and open source tool (VBA) for enhancing your VBA Project with Mulithreading capabilities. It was designed to make VBA multithreading quick an easy and to minimize the complexity of your VBA code. VBA is natively singlethreaded hence will utilize only a single logical processor core. Why […]
MS Office
Invoke VBA functions and procedures from strings
First let me start with explaining what does it mean to invoke VBA functions and procedures from strings. Then I will follow with an example. Lastly I will conclude this topic showing how you can add arguments. Invoke VBA functions and procedures by string name Normally you would invoke a VBA function or procedure like […]
Personal budget calculation in Excel
Today I decided to share something on the topic of managing your personal finances. Everyone should once in a while do a personal budget calculation. If you do not know how much you earn and spend it is a real challenge to manage your personal finances. How to estimate which car you can afford? How […]
Multithreading VBA – VBA worker threads via VBscript
Yet again I am approaching the subject of multithreading in VBA. This time I am coming with an interesting alternative to multithreading in VBA compared to the ones I presented previously. So again let me start by repeating that multithreading is possible in VBA but not in “native” VBA. What do I mean by “native”? […]
Multithreading VBA – VBA vs. VBscript vs. C#.NET
I you were looking for an end-to-end analysis of the topic of multithreading VBA. You have come to the right place! So lately I have been really wearing out the topic of multithreading in Excel in VBA. Hopefully you have already read through my three posts on the various methods of achieving multithreading capabilities in […]