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

See
http://spreadsheetpage.com/index.php...ars_the_movie/

and if your code doesn't know how long it will take to finish, see
http://www.dailydoseofexcel.com/arch...-progress-bar/

HTH. best wishes Harald

"stefan schneider" skrev i melding
...
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

Hi Harald,

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

stefan

Harald Staff schrieb:
See
http://spreadsheetpage.com/index.php...ars_the_movie/

and if your code doesn't know how long it will take to finish, see
http://www.dailydoseofexcel.com/arch...-progress-bar/

HTH. best wishes Harald

"stefan schneider" skrev i melding
...
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

On Apr 16, 9:05*am, "Harald Staff" wrote:
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

"stefan schneider" skrev i . ..

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