Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer
Hello,
I was wondering how I could set an internal time process into a macro. Such as how long the macro has been running. My thought is to display a progress bar that will show the macros percentage of completion. From a response I received yesterday (Thank You), I would like to use something similar to what is on the site http://www.j- walk.com/ss/excel/tips/tip34.htm. My only problem is determining how the percentage is calculated - my thought is to test how long the macro takes to run - then write that time into my code - subtracting that time from the amount of time the macro has been running. But how could I setup this internal timer? Any alternative suggestions would also be greatly appreciated. Thank You! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timer
Hi TJ -
There's a VBA function called Timer which returns number of seconds since midnight. You could call this once at the beginning of the function to save the initial value, than call it periodically later to calculate number of seconds elapsed since the start. Mark "TJ" wrote in message ... Hello, I was wondering how I could set an internal time process into a macro. Such as how long the macro has been running. My thought is to display a progress bar that will show the macros percentage of completion. From a response I received yesterday (Thank You), I would like to use something similar to what is on the site http://www.j- walk.com/ss/excel/tips/tip34.htm. My only problem is determining how the percentage is calculated - my thought is to test how long the macro takes to run - then write that time into my code - subtracting that time from the amount of time the macro has been running. But how could I setup this internal timer? Any alternative suggestions would also be greatly appreciated. Thank You! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lap-timer | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
Timer | Excel Programming | |||
Timer | Excel Programming | |||
Timer | Excel Programming |