ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Run two macros in the same time. (https://www.excelbanter.com/excel-programming/364722-run-two-macros-same-time.html)

emil

Run two macros in the same time.
 
Can I run two macros in the same time?
Thank for the help
Emil.


Jim Cone

Run two macros in the same time.
 
Emil,
No you cannot. However, you can "call" a macro from a macro...

Sub MacroToStart
'code to run first
'call the other sub...
MacroDoSomething
'more code that will run after the MacroDoSomething sub is complete.
End Sub

Sub MacroDoSomething
'lots of code to do something else
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"emil"
wrote in message
Can I run two macros in the same time?
Thank for the help
Emil.


emil

Run two macros in the same time.
 
Thanks, but is not in a same time.
Emil

"Jim Cone" a scris:

Emil,
No you cannot. However, you can "call" a macro from a macro...

Sub MacroToStart
'code to run first
'call the other sub...
MacroDoSomething
'more code that will run after the MacroDoSomething sub is complete.
End Sub

Sub MacroDoSomething
'lots of code to do something else
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"emil"
wrote in message
Can I run two macros in the same time?
Thank for the help
Emil.



Jim Thomlinson

Run two macros in the same time.
 
You can not make 2 macros run at the same time. Post your code and perhaps we
can speed up the macros so that you will have no need to run two porcesses
concurrently.
--
HTH...

Jim Thomlinson


"emil" wrote:

Thanks, but is not in a same time.
Emil

"Jim Cone" a scris:

Emil,
No you cannot. However, you can "call" a macro from a macro...

Sub MacroToStart
'code to run first
'call the other sub...
MacroDoSomething
'more code that will run after the MacroDoSomething sub is complete.
End Sub

Sub MacroDoSomething
'lots of code to do something else
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"emil"
wrote in message
Can I run two macros in the same time?
Thank for the help
Emil.




All times are GMT +1. The time now is 06:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com