Progress Bar

[stefan schneider]

Hello,

i have a big worksheet with a long time running macro. Is there a way to
implement a progressbar in an easy way, so the user can see how long he
has to wait to finish the macro?

Is it possible to place the progressbar e.g. in the middle of the screen?

Thanks for your efforts.

Best Regards

stefan

 

[Harald Staff]

See
http://spreadsheetpage.com/index.php/blog/progress_bars_the_movie/

and if your code doesn't know how long it will take to finish, see
http://www.dailydoseofexcel.com/archives/2007/02/10/yet-another-progress-bar/

HTH. best wishes Harald

 

[stefan schneider]

Hi Harald,

thanks. Seems to be difficult. I have to try next days.

stefan

 

[TD]

Seehttp://spreadsheetpage.com/index.php/blog/progress_bars_the_movie/

and if your code doesn't know how long it will take to finish, seehttp://www.dailydoseofexcel.com/archives/2007/02/10/yet-another-progr...

HTH. best wishes Harald