VBA: Pausing Code Execution

M

Michael Loganov

Hi,

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

Thanks in advance
Mike
 
C

Chip Pearson

Mike,

Try something like the following:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Pause an Excel VBA script without freezing excel 1
Stop Command Question 4
How to pause without being "modal" 1
pause 4
Pause a macro by resetting current time 3
Pausing a macro during execution 1
VBA equivalent for WScript.Sleep 3
pause vba code until user pastes values in spreadsheet 2

Top