Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hello, Need help with time msg
I would like to have a message appear at the end of my macro telling me how
long it took to complete all of its steps, and then an okay button to close the window. how would one add this to a recorded macro? and how do i tell it to give me the time length to include hundredths of a second. And I've never added a msg before in my macros. Thanks in advance G |
#2
|
|||
|
|||
To time it, add a statement like
nStart = Timer at the start, and Msgbox Timer - nstart at the end. This will be seconds -- HTH Bob Phillips "Greegan" wrote in message ... I would like to have a message appear at the end of my macro telling me how long it took to complete all of its steps, and then an okay button to close the window. how would one add this to a recorded macro? and how do i tell it to give me the time length to include hundredths of a second. And I've never added a msg before in my macros. Thanks in advance G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time | Excel Discussion (Misc queries) | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
Time Sheets | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions |