I have a macro that pulls values from a text file into an excel spreadsheet.
As values are being added to the sheet, I have a line chart that changes to reflect the addition of those numbers.
I looks very cool!
The problem is that it flickers.
I have read about the screenUpdating = True/False to eliminate the flickering, but when I used it, the chart did not update until the very end.
That's not as cool!
Is there anyway that I can see the chart update without the flickering?
As values are being added to the sheet, I have a line chart that changes to reflect the addition of those numbers.
I looks very cool!
The problem is that it flickers.
I have read about the screenUpdating = True/False to eliminate the flickering, but when I used it, the chart did not update until the very end.
That's not as cool!
Is there anyway that I can see the chart update without the flickering?