Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slowing Down a Macro
You have to insert wait times. Here is a quick (or rather slow) example...
Run the test sub... Public Sub Pause(ByVal WaitTime As Integer) Application.Wait Now + TimeSerial(0, 0, WaitTime) End Sub Sub test() MsgBox 1 Pause 2 MsgBox 2 Pause 4 MsgBox 3 End Sub -- HTH... Jim Thomlinson "tedd13" wrote: Hello, I am wondering if it is possible to slow the speed down on how fast a macro runs. For example, if you bring up the VB Editor and press the F8 key the macro will run as long as you hold down the key (or you can just press the key over and over). Doing this lets you see what is going on as the macro runs. However, if you press the play button the macro will run...very fast. It runs so fast that you can't see what's going on. So is there a way to slow down how fast it runs? In some cases I would like the users to be able to see what the macro is doing. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
slowing down | Excel Discussion (Misc queries) | |||
Macro slowing down gradualy... (duplicate post - use this) | Excel Programming | |||
Macro and slowing a progress bar. | Excel Programming | |||
Macro slowing down after a while... | Excel Programming | |||
Slowing Macro | Excel Programming |