I have a single line of code that takes a long time to run. (This is because it is either accessing or writing to a network location.)
I want to run a Form_Timer event during this to animate a rotating hourglass (just to show the user something is happening so they don't go click-crazy).
I learned VBA doesn't support concurrency, which I take to mean I can't run the Timer event while my longrunning subroutine executes. Because my longrunning subroutine really is a single longrunning line of code, I can't use DoEvents to free up the processor.
Is there a concurrency workaround for this case, or should I find another way to let the user know their system is at work?