Hi Guys,
I've built a looper animation to entertain users while my code is saving data. It is quite simple form with 8 rectangles that dynamically change their RGB color to achieve an effect of "chasing tail". It works, but If I load it from other code, it stops the calling code from continuing..
The animation uses 2 for..next loops and 1 do... Loop. It also contains DoEvents statement (otherwise it freezes few seconds after firing).
What should I do to keep calling code continuing while my animation form is also running? In other words how to keep 2 forms (with 2 blocks of code) being processed at the same time?
Robert
EDIT: I did more searching and I learned that VBA doesn't support multithreading.. so it can't run code A and code B at the same time. It is either one code after another or the calling code stops until called code has finished and then starts where it previously stopped.. Not good... I found few workarounds but none actually worked good for me.
I think this topic can be deleted or left of other interested
Robert