CODEWITHSUNDEEP
vbaexcelexcel-formulaexcel-2010
Alex Ferg
Alex Ferg

Reputation: 881

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

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?

Upvotes: 1

Views: 2326

Answers (1)

Gary's Student
Gary's Student

Reputation: 96791

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.

Upvotes: 2

Related Questions