Hello, Need help with time msg

  • Thread starter Thread starter Greegan
  • Start date Start date
G

Greegan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top