N
nc10001
I am running a macro which simulates an engineering application. The
macro essentially time steps, sending the data at each time step to a
worksheet, and a chart is set up to display the data in graphical
form.
Problem - although the worksheet is updated at each time step, the
chart only updates when the macro has finished executing - and I want
to see the data being graphed as the simulation proceeds - is there
anyway of getting the macro to pause while the chart is updated - some
kind of handshake between EXCEL and the macro? (At the moment the only
way I can do this is to put a STOP in the code loop.)
Thanks in advance
nc10001
macro essentially time steps, sending the data at each time step to a
worksheet, and a chart is set up to display the data in graphical
form.
Problem - although the worksheet is updated at each time step, the
chart only updates when the macro has finished executing - and I want
to see the data being graphed as the simulation proceeds - is there
anyway of getting the macro to pause while the chart is updated - some
kind of handshake between EXCEL and the macro? (At the moment the only
way I can do this is to put a STOP in the code loop.)
Thanks in advance
nc10001