Timer to measure macro run time

[Fishboy]

Hi all,

I have an Excel 2010 workbook that contains a number of lengthy, time consuming macros. What I would like to do is find a way of incorporating a timer / stopwatch to my macros which starts timing when the macro initializes and stops counting when the macro reaches conclusion. Ideally I would like to incorporate the result into my current MsgBox which pops on on completion. It would read something along the lines of "This macro completed in XXmins:XXseconds" if possible.

Having Googled Excel timer functions I am fairly sure this should be possible, however I am at a loss as to how to achieve it.

As always, any help is greatly welcomed.

 

[vcoolio]

Hello Fishboy,

Have a look at the following article:-

VBA Code To Calculate How Long Your Macro Takes To Run

I'm pretty sure its what you're after and will be easy to implement into your existing code.

Cheerio,
vcoolio.

 

[Fishboy]

Hello Fishboy,

Have a look at the following article:-

VBA Code To Calculate How Long Your Macro Takes To Run

I'm pretty sure its what you're after and will be easy to implement into your existing code.

Cheerio,
vcoolio.

Thanks vcoolio, that is perfect.

 

[vcoolio]

No worries, Fishboy. Its worth keeping an eye on Chris Newman's site. Very insightful, easily understood and he answers e-mails!

Take care.

Cheerio,
vcoolio.