View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Whoa horsie Slow down

Pete,
Another way from mskb 162150 ...

Use an API call to suspend execution for a fixed amount of time.
The Kernel32 contains a function that pauses a program's execution for a
specified amount of time, specified in milliseconds. To use the function, it
must first be declared in the General Declarations section of the module in
which it will be used:
'--------------------------------------------------
Declare Sub Sleep Lib "kernel32" Alias "Sleep" _
(ByVal dwMilliseconds As Long)

'Use the following syntax to call the Sleep function:
Sub Sleep()
Sleep 1000 'Implements a 1 second delay
End Sub
'--------------------------------------------------
Regards,
Jim Cone
San Francisco, CA

"Pete" wrote in message
...
Can anyone tell me how to slow down macro or choose how
fast a macro runs. If you have a macro with screen
updating turned on I want it to slow down enough to view
the date being entered.
Any ideas on this.
Pete