Excel VBA Re-run formulas (update) when any cell in sheet changes -

Excel VBA Re-run formulas (update) when any cell in sheet changes -

i've written function in vba homecoming value based on cells' values. execute/run function in formula on cell

=myfunction()

my problem is, cells have above formula don't automatically update if cells used in function (in vba) changed.

how can re-run or update or re-execute above formula if cells used changed?

you must recode udf accomplish desired volatility. want udf re-calculate if a1 or b1 or c1 changed, use:

=myfunction(a1,b1,c1)

using arguments gets required volatility.

excel vba excel-vba excel-formula excel-2010