How to Determine When Calculations are Complete
You could put a message box at the end of your code, like this :
n = MsgBox("Calculations completed !",vbOkOnly)
--
If the post is helpful, please consider donating something to an animal
charity on my behalf.
"Alan" wrote:
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
.
|