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