Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Execute Macros through Hyperlinks. | Excel Programming | |||
How to execute Macros through Text Links? | Excel Discussion (Misc queries) | |||
Multiple simultaneous macros and userforms | Excel Programming | |||
How to execute macros not saved in a workbook | Excel Programming | |||
Execute macros under Excel and Oulook XP | Excel Programming |