Progress Bar in Excel

  • Thread starter Thread starter Neeraja
  • Start date Start date
N

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
 
Back
Top