Progess of a macro in a form 1

[pkrmott]

I would like a form to pop up and give a progress statement for a fairly long-winded macro I have written. Something along the lines of "33 of 10,000 complete" would be excellent, and I do not want to use the status bar (it's being used for something else already).

At present, I have a form and i load it when the macro is started with the command...

StatusForm.Show vbModeless

"StatusForm" is the name of my form.

My macro pulls data from a number of different spreadsheets and the web, so it is jumping around all over the place. My biggest confusion is that if I update a textbox in the form (with a comment like "33 of 10000 complete"), and have the macro "sleep" the form does not become visible. Even if I unload it and use the show command to bring it back again, it stays greyed out. Has anyone ever run into this issue before? I'd appreciate any thoughts.

 

[firefytr]

Check out this Dual Progress Bar Knowlege Base entry ...

http://vbaexpress.com/kb/getarticle.php?kb_id=169

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[pkrmott]

Firefytr, thanks a million. I was able to use the code you directed me to and eventually traced my problem back to the fact that I had not included a "DoEvents" command where one was (apparently) necessary. Thanks again for the helpful post.

 

[firefytr]

You're welcome. Glad you got it sorted!

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci