DoEvents essentially makes the current VBA process "yield" to other processes that are currently in the queue. I think it was designed to be used to (for example) refresh a display counter whilst running a loop but I think you can also use it to avoid issues with code executing the next line(s) before the previous command has been completed. I suggested it as I assumed it would be quicker than using ontime to make it wait a second but if it doesn't work I wouldn't bother too much with it. You may have more success with something like sleep, as you can use time amounts < 1 second which may speed things up whilst still functioning correctly. You need to declare the API:
and then
would "pause" for 100ms.
Afraid I can't access facebook links from work but yes, I am an acoustic engineer by trade.
Bookmarks