Posted on 08 November 2008
This article describes 3 ways of simulating multithreading in VBA using Excel.
One feature that I sorely miss in the VBA's integrated development environment (IDE) is the ability to do multithreading. I think part of that comes from having worked in my previous avatar with Java and C++.
In the past few days I’ve been thinking about ways in which one can ‘simulate’ multithreading in excel. (If you noticed, I said ‘simulate’ – you can’t actually multithread with vba – not atleast ...