View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Record time peroid to run code

Sub TestTime()
Dim StartTime As Single
StartTime = Timer

'do code here

MsgBox "Code took " & Timer - StartTime & " seconds"
End Sub
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"gotroots" wrote:

Hi

Is there a msgbox method that will record the length of time it take for
code to complete its execution.

Thank you.