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.
|