ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   execute simultaneous macros (https://www.excelbanter.com/excel-programming/390875-execute-simultaneous-macros.html)

Robert[_33_]

execute simultaneous macros
 
I would like to execute 2 macro´s at the same time. Something like
this:

Private Sub SimulationStart_click()

Do Until Range("B14").Value 1.2
Call ProcessCalculate ' runs calculations in the workbook.
Call LabelChange ' runs on a userform.
Loop

End Sub

The macro Processcalculate takes about 15 seconds to reach the value
1.2.

It seems that the macro labelchange executes when processcalculate is
done =(

Does anyone has an explanation for this?


Bob Phillips

execute simultaneous macros
 
LabelChange will not run until ProcessCalculate completes. If you want the
code from the former to run with the latter, put it into a single procedure.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Robert" wrote in message
ups.com...
I would like to execute 2 macro´s at the same time. Something like
this:

Private Sub SimulationStart_click()

Do Until Range("B14").Value 1.2
Call ProcessCalculate ' runs calculations in the workbook.
Call LabelChange ' runs on a userform.
Loop

End Sub

The macro Processcalculate takes about 15 seconds to reach the value
1.2.

It seems that the macro labelchange executes when processcalculate is
done =(

Does anyone has an explanation for this?




All times are GMT +1. The time now is 03:56 PM.

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