Vba screen updating off
Wait Date Add("n", 1, Now) 'Wait for 1 hour Application.
Wait Date Add("h", 1, Now) 'Wait for 1 minute 30 seconds Application.
Wait Date Add("s", 90, Now) ' = 60 30 'Wait for 1 hour 2 minutes and 30 seconds Application.
Wait Date Add("s", 3750, Now) ' = 3600 120 30 at any time and resume control over your project.
The procedure pauses code execution for a certain amount of time putting the whole processes in a type of coma.
Should you need something a little more accurate you might want to investigate the Timer function instead.
If you thought those were your only options – you were wrong.
VBA thankfully allows you to also use another function called Do Events. Seriously, it doesn’t do anything more that handle all MS Office events.
The Sleep function pauses the entire process for a certain delay specified in milliseconds.
The drawback of using VBA Sleep is that it freezes Excel until the delay is done. Wait is a native VBA function that pauses code execution until a certain time is reached.