Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a VBA macro
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA macro pausing | Excel Worksheet Functions | |||
Pausing a macro | Excel Discussion (Misc queries) | |||
Pausing Macro | New Users to Excel | |||
Is there a way of pausing a macro | Excel Discussion (Misc queries) | |||
Pausing a Macro | Excel Discussion (Misc queries) |