Update or refresh plot while VBA running

ernieL

New Member
Joined
Apr 25, 2014
Messages
4
I have a program which iterates on command. A plot on the spreadsheet is designed to show the progress of the iteration. However, the plot does not update while VBA is running. What is the command or technique to refresh the plot at an intermediate stage in the calculation?
Regards,
ernieL
 

ernieL

New Member
Joined
Apr 25, 2014
Messages
4
Just put the command DoEvents into the code where the update should occur.
ernieL
 

Forum statistics

Threads
1,082,550
Messages
5,366,257
Members
400,880
Latest member
aforte

Some videos you may like

This Week's Hot Topics

Top