Pausing or delaying VBA using Wait, Sleep or a loop
3 April 2015
You may want some way of pausing or delaying VBA code execution and you can do this with two functions called
Sleep. You can also do this using a loop, and we will look at that approach too.
Why would you pause the code? Maybe you need to wait for another task to finish, for instance if you made a call to a Windows API/shell function. Or you may want to wait for the user to update data in the sheet, or you just want to run a macro at a set time.