execute simultaneous macros

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

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?
 
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)

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?
 
Back
Top