Macro progress bar using VBA - How?

**cssriraman** · Mar 31st, 2006, 11:22 PM

When macros take a long time to run, people get nervous. Did it crash? How much longer will it take? Do I have time to run to the bathroom? Relax.

So, what are the ways to create a macro progress bar using VBA?

Thanks in advance.

**zaza** · Apr 1st, 2006, 05:24 AM

You can add a progress bar to Excel spreadsheets from the toolbox - you need to look in the extended list of controls, or you could put one on a userform and show that. I don't think that Word allows them on the document itself, but I may be wrong.
Then you just increment the progress bar during your macro loop as you would normally.

zaza

**RobDog888** · Apr 1st, 2006, 01:54 PM

Which Office app are you needing it in and version?

**cssriraman** · Apr 2nd, 2006, 07:48 AM

MS Word 2003. if we use progress bar the progress is not showing.

**RobDog888** · Apr 2nd, 2006, 09:39 AM

Did you add it to a userform?

**cssriraman** · Apr 2nd, 2006, 11:32 AM

Yes. the progress bar is added to user form only.

**RobDog888** · Apr 2nd, 2006, 11:41 AM

Ddi you already add the code to monitor your progress?

Thread: Macro progress bar using VBA - How?

Thread Tools

Display

Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Re: Macro progress bar using VBA - How?

Posting Permissions