Running Macro in Excel

[Randy]

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

 

[Guest]

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

 

[Bob Phillips]

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

 

[Stephen Bullen]

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