Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine When Calculations are Complete
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Determine When Calculations are Complete
Paul,
Thanks for the suggestion, but I need to detect this in the VBA code, not notify the user. In fact, it would be a nuisance to the user in some cases. Alan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto complete only for one row down? | Excel Discussion (Misc queries) | |||
Using date format in the cells how determine percent complete | Excel Worksheet Functions | |||
Auto Complete | Excel Discussion (Misc queries) | |||
MACRO IS NOT COMPLETE | Excel Programming | |||
formulas disappear after calculations are complete | Excel Worksheet Functions |