When running macros in excel, some run from several seconds to minutes
depending on the amount of data. Is there a way to show a progress
bar showing the percent of completion of the macro like when a file is
downloading from the internet.

Thanks in advance
Randy

Hi,

the best way is to put a progress bar control on a non-modal userform that
you load at the start of the procedure, and update the value either in the
loops that take time, or just after each big step.

There are also some other cool options on many good sites such as Stephen
Bullens: http://www.BMSLtd.co.uk

and Chip Pearspn too: http://www.cpearson.com/excel/whatsnew.htm

HTH

Philip


"Randy" wrote:

When running macros in excel, some run from several seconds to minutes
depending on the amount of data. Is there a way to show a progress
bar showing the percent of completion of the macro like when a file is
downloading from the internet.

Thanks in advance
Randy

Take a look at http://j-walk.com/ss/excel/tips/tip34.htm

--
HTH

-------

Bob Phillips
"Randy" wrote in message
om...
When running macros in excel, some run from several seconds to minutes
depending on the amount of data. Is there a way to show a progress
bar showing the percent of completion of the macro like when a file is
downloading from the internet.

Thanks in advance
Randy

Hi Philip,

There are also some other cool options on many good sites such as Stephen
Bullens: http://www.BMSLtd.co.uk

Thanks for the plug, but my site is now at http://www.oaltd.co.uk

Regards

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