Figureing out how long a sub takes to execute

[Brian Henry]

I want to time how long a specific sub takes to execute, what is the best
way to do this? this is only for one sub, and i just need a result back in
milliseconds or such to display to a user. thanks!

[M. Posseth]

this will do the trick
Dim substart As DateTime = Now

'some code here

MsgBox("pause") 'just for testing
Dim elapsed_time As TimeSpan
Dim subEnd As DateTime = Now
elapsed_time = subEnd.Subtract(substart)

MsgBox(elapsed_time.TotalMilliseconds())

regards

Michel Posseth

"Brian Henry" wrote:

I want to time how long a specific sub takes to execute, what is the best
way to do this? this is only for one sub, and i just need a result back in
milliseconds or such to display to a user. thanks!

[Herfried K. Wagner [MVP]]

"Brian Henry" <no****@nospam.com> schrieb:

I want to time how long a specific sub takes to execute, what is the best
way to do this? this is only for one sub, and i just need a result back in
milliseconds or such to display to a user.

<URL:http://www.mentalis.org/soft/class.qpx?id=8>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>