Excel VBA Re-run formulas (update) when any cell i

Question

I've written a Function in VBA to return a certain value based on certain cells' values. I execute/run this function in a formula on a certain cell

=MyFunction()

My problem is, the cells which have the above formula don't automatically update if the cells used in the function (in VBA) are changed.

How can I re-run or update or re-execute the above formula if the certain cells that are used are changed?

Answer 1

You must recode your UDF to achieve the desired volatility. Say you want the UDF to re-calculate if A1 or B1 or C1 are changed, then use:

=MyFunction(A1,B1,C1)

Using arguments gets the required volatility.