Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simultaneous protection | Excel Discussion (Misc queries) | |||
Simultaneous calls | Excel Worksheet Functions | |||
How do I do simultaneous AND and OR filtering ? | Excel Discussion (Misc queries) | |||
simultaneous subtotals | Excel Discussion (Misc queries) | |||
Simultaneous Filtering | Excel Worksheet Functions |