Macro progress bar using VBA - How?

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.

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

Which Office app are you needing it in and version?

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

Did you add it to a userform?

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

Ddi you already add the code to monitor your progress?