simultaneous run
 

Hello,

Is it possible to run two macros simultaneously? I would
like to show a dialog box or a timer or something
interesting (like a be patient box) while my macro is
running. How would I go about doing this, and any
suggestions on a timer box would also be helpful.

Thank You,

simultaneous run
 

Hi TJ

Maybe you like this
http://www.j-walk.com/ss/excel/tips/tip34.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"TJ" wrote in message ...
Hello,

Is it possible to run two macros simultaneously? I would
like to show a dialog box or a timer or something
interesting (like a be patient box) while my macro is
running. How would I go about doing this, and any
suggestions on a timer box would also be helpful.

Thank You,

simultaneous run
 

You don't need to run two macros - show a userform to display something and
write an update to this form periodically from your running macro. I often
use a textbox and write a new value showing the current progress through a
long process.

Something like....

Sub LongMacro()
userform1.show

call TellUser("Running Step1")
code to do step 1

call TellUser(Running Step2")
code to do step 2 etc

End Sub

Sub TellUser(tbMess as String)
userform1.textbox1.value = tbMess
DoEvents
End Sub

Cheers
Nigel

"TJ" wrote in message
...
Hello,

Is it possible to run two macros simultaneously? I would
like to show a dialog box or a timer or something
interesting (like a be patient box) while my macro is
running. How would I go about doing this, and any
suggestions on a timer box would also be helpful.

Thank You,