View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cjsasl cjsasl is offline
external usenet poster
 
Posts: 1
Default Get time it takes to run program!!


Hello all, I have a macro set-up to check a through a range of cell
looking for members code 1 & changing it to a sequential number
dependent code 2 & setting it to null.

What I'd like to do is when it pops up the msgbox at the end informin
the user how many members records were changed & dependent record
changed I can also include something like "Task completed in #
seconds".

How do I set up a timer to count of the seconds from the start of th
code until the last record has been changed?

Do you need me to post the code I have written so far?

Thanks in advance,

eri

--
cjsas
-----------------------------------------------------------------------
cjsasl's Profile: http://www.excelforum.com/member.php...fo&userid=2871
View this thread: http://www.excelforum.com/showthread.php?threadid=48400