View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina faustino Dina is offline
external usenet poster
 
Posts: 10
Default Pausing a VBA macro

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.

"Dean Taylor" wrote in message
...
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.