Pausing a VBA macro

[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.

 

[faustino Dina]

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.