modal status window?

[Lucas Karpiuk]

i'm familiar with StatusBar, but i was wondering if there is any way to make
some kind of modal display similar to a MsgBox but without any buttons, and
have the text updated at various points by the macro and then eventually
closed?

thanks in advance!

 

[Tony Jollans]

You can't have a message box without buttons - and controlling it without
user interaction is hard work.

Create a little userform and put what you want on it, when you want, and
hide and unload it when you're done.

I'm sure someone will post a link to somewhere with information about
creating a progress bar (which sounds like what you want) but I'm new here
and don't know all the links yet.

 

[Lucas Karpiuk]

Thank you, Tony - "Progress Bar" in google got me to exactly what I need,
after some minor modifications.

http://word.mvps.org/FAQs/Userforms/CreateAProgressBar.htm