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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

ernieL

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

Watch MrExcel Video

Forum statistics

Threads
1,118,048
Messages
5,569,879
Members
412,298
Latest member
dietitiann
Top