display how long it takes to calc or timing certain events

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?"

http://support.microsoft.com/default...b;en-us;172338
How To Use QueryPerformanceCounter to Time Code

--
Regards,
Tom Ogilvy


"GH" <gwh_lbh@swbell.net> wrote in message
news:1105725429.626024.218130@c13g2000cwb.googlegroups.com...
> 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?"
>

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.


---
Regards,
Norman



"GH" <gwh_lbh@swbell.net> wrote in message
news:1105725429.626024.218130@c13g2000cwb.googlegroups.com...
> 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?"
>

I have a Speed Test example on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"GH" <gwh_lbh@swbell.net> wrote in message
news:1105725429.626024.218130@c13g2000cwb.googlegroups.com...
> 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?"
>

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