VBA question- how to show message with code status?

[quanttrade99z]

Hi All-
hoping someone can help me with a VBA question...
I am running some code which takes some time to run.
I want to show a message to the user which says something like->
"finished running XXX"
"finished running YYY"
as the code runs through the loops/subs/etc.

MsgBox can't do this because it is a one shot deal, right? i.e. you show your text and are stuck with it.
Forms seem problematic because code doesn't run in the background while they are being shown right (unless you call the code from the form).

Any simple solutions? Something like a msgbox that wouldn't pause code execution, but would allow me to change the text it was showing from time to time would be great!

Thanks!
quanttrade

 

[KLin]

You can have a text box on the form and have it update the text box after the loop finishes and repaint the form. See my lame sample .