execute simultaneous macros

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

Bob Phillips

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top