Include a volatile function in one of the cells referenced by your UDF. If that doesn't work you can also try adding Shift which additionally rechecks dependent formulas before recalculating. Force Excel to manual recalculate all of the formulas in the workbook even if they have not changed since the last calculation by pressing Ctrl+ Alt+ F9 on Windows and (I assume on Mac) Cmd+ Alt+ F9.You can work around this behavior in several ways: MsgBox 'The target cell's address is ' & Target.AddressĪnd in cell A1 on my worksheet I reference the cell with the formula: =MyFunction(A2)ĭuring normal use of my workbook, the code of my UDF will only be called if there's a change to the contents of cell A2 or another cell referenced by a formula in A2. Excel only runs the code of a UDF when the cell(s) that serve as input to the function change.įor example, suppose I have this UDF: Public Function MyFunction(Target As Range) You've created a User-Defined Function (UDF). Excel Recalculates UDFs Only When Their Input Changes
