Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/workseet/graph interaction
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/workseet/graph interaction
Make sure you have Application.Screenupdating = true and try using the
DoEvents function. Or you could use OnTime to run the elements of your simulation at the time intervals you require. Seisman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro interaction | Excel Discussion (Misc queries) | |||
chart/worksheet/macro interaction | Charts and Charting in Excel | |||
macro/worksheet/chart interaction | Excel Discussion (Misc queries) | |||
How can I stop a macro for Human Interaction | Excel Programming | |||
Make Macro go to Next Workseet | Excel Programming |