Progress Bar in Excel

[Neeraja]

Hi,

Is it possible to Display Progress bar which runs on its
own with a Macro?? Actually i have seen in one of the
sites that it is possible but our program needs to
control the width of the Progress bar.

My MAcro takes a longer time to run. So i want to
include a progress bar. The macro makes use of multiple
columns and rows and of different ranges. So i am really
unable to control the width in a proper way so that at
the time the MAcro reaches Completion its width is 100%.
Its like the execution of macro is completed by the time
the width of progress bar is just 40% sometimes.. and
things like that. I hope i am able to make myself clear!!!

Is there any way i can solve this???? I need a
progress bar which recognises the total time of execution
of macro and its width is taken care of by itself.

Could someone suggest me if i can do it this way!!!!

Thanks in Advance for any help.
Neeraja

 

[pfsardella]

John Walkenbach has some info on how to create a ProgressBar using a
UserForm as a base.

http://j-walk.com/ss/excel/tips/tip34.htm

It's difficult to say why your current setup does not work
satisfactorily without actually seeing how the width is being filled.

HTH
Paul