![]() |
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? |
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