Progress Indicator
What is wrong with the progressbar control that comes with Excel?
Just put it on a form and set it's value in the loop. These values have to
be between 0 and 100.
Can't be simpler and I never found any problem with them. I am not sure
though if it is in Excel
versions below 9.
RBS
"Rob Hargreaves" wrote in message
...
Hi I need to find a simple to use progress indicator for excel. I cant
use one which requires a dll or any references.
cpearson has a nice looking one but that does!!
jwalks example only works in some of my code. The loops are quite tight
in the example I want to use one with and it is part of an automated task
between excel and word.
Any suggestions would be great. Graphical ones would be better on a form
which updated an indicator or progress bar whilst the code was being
executed.
(The current code takes 1/2 hour to finish)
Thanks for any help,
Rob
|