Pausing a VBA macro

  • Thread starter Thread starter Dean Taylor
  • Start date Start date
D

Dean Taylor

Is there any VB function (other than 'Wait') that allows
you to pause execution of a VB macro for a specified time?

The minimum pause allowable with the 'Wait' utility appears
to be 1 sec, but I only want to pause for a small fraction
of a second.
 
It should work. Copy the following line at the very beginning of your
module:
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Then call in your subroutine:
Sleep(5000) ' for a delay of 5 seconds.
 
Back
Top