VBA: Pausing Code Execution
 

Hi,

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

Thanks in advance
Mike

Pausing Code Execution
 

Mike,

Try something like the following:

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Michael Loganov" wrote in message
...
Hi,

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

Thanks in advance
Mike

Pausing Code Execution
 

Thank you

Mike

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