VBA: Pausing Code Execution

[Michael Loganov]

Hi,

how can I pause a code execution for, let's say 5 seconds?

Thanks in advance
Mike

 

[Chip Pearson]

Mike,

Try something like the following:

Application.Wait Time:=Now + TimeSerial(0, 0, 5)

 

[Mike L]

Thank you

Mike

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!