VB - Excel : Auto Update from VB to Excel?

Question

Is there a way to auto-update the cells in Excel from a code in VB WITHOUT using (especially infinite) loop?

If yes, Please provide example

Thank you

Answer 1

Yes, there is:

Calculate

Or

Application.Calculate

will calculate all of the cells in all of the open workbooks. You can also specify to calculate a specific worksheet or range by adding:

.Calculate

after specifying the worksheet or range.

If you want to look it up, look up the Calculate Method in the Visual Basic Editor help topics. I found out about it by recording a macro then pressing F9 to refresh or auto-update the values. Then I went back and looked up the code that was recorded. Then I went into help and looked up what the Calculate Method and Calculate Event do.

Answer 2

Never done this before myself. Maybe this link will help.

http://www.astahost.com/ms-excel-automatic-update-data-t11008.html