How to Determine When Calculations are Complete
"Alan" wrote:
My question: How can I be certain that calculations
are completed, before I change the cell value, which
causes recalculation?
I would use the Worksheet_Calculate (in a particular sheet object) or
Workbook_SheetCalculate (in the ThisWorkbook object) event macro, depending
on your requirements. In VBA Help, enter calculate and sheetcalculate to
descriptions.
Be sure to set Application.EnableEvents = False within the event macro,
since you indicate that you will make changes that cause recalculation. Be
sure to use On Error to ensure that you set Application.EnableEvents = True
before exiting. Other precautions might apply.
----- original message -----
"Alan" wrote in message
...
I have some (many) equations in a spreadsheet. I have to change a
cell in the spreadsheet, which affects all the calculations, until
certain conditions are met. I check these conditions and change the
cell using VBA code.
My question: How can I be certain that calculations are completed,
before I change the cell value, which causes recalculation?
Please note that I cannot implement the formulae in VBA code, due to
user requirements.
TIA, Alan
|