Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause a macro by resetting current time
Sub servient()
Application.Wait Now() + 0.000005787037 End Sub -- Gary''s Student - gsnu200846 "SW" wrote: Hi, I am creating a macro which changes the y-values in a distribution plot each second (corresponding to the values the next day). This allows one to see a distribution change over time. The problem I have is I found the following code to pause in between (so one can see the distribution shifting over time) the dates but it pauses it for 1 second and I need it to pause it for about half a second only. Here is the code (for pausing) that I currently have: newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 1 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime Any help greatly appreciated, thanks a million! SW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
Macro for recording current time into other cell | Excel Programming | |||
Pause a macro for some time | Excel Programming | |||
programming a macro to display the current time | Excel Programming | |||
macro for current time | Excel Discussion (Misc queries) |