display how long it takes to calc or timing certain events

[GH]

The glorious excel application that I have been constructing over the
past month is getting very sloooooowwwwww. I have done the obvious
like turning off screen updating and turning off automatic calculation
while the code is running and pasting stuff in cells.

Even the automatic calculation that executes when the user updates a
single cell is slow.

I would like to time how slow. Can you somehow display a clock or
timer to measure whether certain modification to the code improve the
speed? I would like to be able to quantify questions like: "How much
faster is the calculation if all UDF functions are made non-volatile?"

 

[Tom Ogilvy]

http://support.microsoft.com/default.aspx?scid=kb;en-us;172338
How To Use QueryPerformanceCounter to Time Code

 

[Norman Jones]

Hi GH,

As an alternative, I like Karl E Peterson's Stopwatch, freely downloadable
from:

http://vb.mvps.org/samples/project.asp?id=stopwatch

The site is being revamped as we speak, so click on the 'Old Site
description ' link to get a flavour of the many goodies available.

 

[Rob van Gelder]

I have a Speed Test example on my website.

 

[Stephen Bullen]

Hi Gh,

I would like to time how slow. Can you somehow display a clock or
timer to measure whether certain modification to the code improve the
speed? I would like to be able to quantify questions like: "How much
faster is the calculation if all UDF functions are made non-volatile?"

If you can wait a few weeks, our book "Professional Excel Development"
includes a chapter about optimizing VBA performance and provides a
performance monitoring addin that does exactly what you require.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk