Pausing code execution

  • Thread starter Thread starter Rohit Thomas
  • Start date Start date
R

Rohit Thomas

Hello All,

I would like to pause code execution for approx five secs
before running the next set of statements. Is this the
correct code to do that???

****some code here****
Application.Wait (Now + TimeValue("0:00:05"))
****some code here****

Thanks,
Rohit
 
Rohit,

You could try this:

Application.Wait Now + TimeSerial(0, 0, 5)

John
 
You must log in or register to reply here.

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

automation error 0
Running SPSS-Syntax using Excel VBA (Excel 2013) 0
Loop +2, +4, etc. help 5
Application.Wait 2
sheet cycle macro 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Auto closing UserForm 3
awaiting the execution of code... 1

Back
Top