User VBA Functions Calc not Automatic

[EssoExplJoe]

I have several functions defined in VBA that are used in my workbook cells. However, when I change and input data in one cell in the spreadsheet, the functions do not recalculate unless I copy and repaste them. However, if I use ctrl+alt+F9, all are recalculated correctly. I have tried setting the calculation to "automatic" and also selecting the "Calculate Sheet NOW" options under the Formula menu item. How do I get the whole workbook to recalculate automatically when I change one of the input numbers?

 

[bebo021999]

Try to declare the UDF as Volatile function at the second line :

Function ABC(...)
Application.Volatile
...
End function

So this UDF will be triggered if there is any change/update value in sheet.

 

[EssoExplJoe]

Try to declare the UDF as Volatile function at the second line :

Function ABC(...)
Application.Volatile
...
End function

So this UDF will be triggered if there is any change/update value in sheet.

Thanks...the Applicaiton.Volatile statement in each of the UDF's used in my workbook cells recalculates anytime any value changes in any call on the worksheet.