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

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