MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Progress Display


Posted by Sam on July 19, 2001 7:17 AM

Is there any way to have a display box come up during a macro that would display the progress of the macro in either an estimated time left or a percentage bar format?

Thanks for the help,
Sam


Posted by Barrie Davidson on July 19, 2001 7:23 AM

Sam, have a look at
http://j-walk.com/ss/excel/tips/tip34.htm

Don't know how well it works, I've never tried it, but John Walkenbach is a wizard.

Barrie

Posted by faster on July 19, 2001 7:36 AM

In the VB editor goto Tools/Additional Controls.
From there you can add a Microsoft StatusBar
Control to a form.

Posted by Sam on July 19, 2001 9:08 AM

Thanks For The Help

Barrie the site you gave me worked out great. It was pretty easy to get the macro to adapt to my project. It runs very nicely. Thank you for the reference.

Sam