Code Timer

Adding a time to your code.

Dim lDbl_StartTime As Double
Dim lDbl_EndTime As Double
	lDbl_StartTime = Now

	'' - - - - - - - - -
	'' Code here
	'' - - - - - - - - -

	'' Time taken
	lDbl_EndTime = Now

	MsgBox "Time taken: " & _
		Format(CDbl(lDbl_EndTime) - CDbl(lDbl_StartTime), "hh:mm:ss"), _
		vbInformation + vbOKOnly, "Project Title"

Published: 28-May-2005
Last edited: 05-Jun-2005 19:28