Creating a time delay in VBA code

Hi there,

I was trying to get a time delay inserted in the execution of my VBA code. Is there a command which exists wherein we could say like execute the code ahead only after a pause of some 'x' seconds.

Cheers
Goel
GoelsAsked:
Who is Participating?
 
bramsquadCommented:
place this code at the top of your project

Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

then you can call the Sleep() function wherever in your code

Sleep(1000) 'this should equal one second

~b
0
 
GoelsAuthor Commented:
Thanks a lot dear.

Chow Goels
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.