User-defined functions

[tiredofit]

I have created a udf but I can't work out why it gets called more than once?

In Sheet1, I have values in cells B1, D1 and E1.

A1 contains a formula:

=D1+E1

and C1 contains my udf:

=MyCalc(B1,A1)

Here is the code:

Option Explicit

Sub Test()
  
    Sheet1.Cells(1, 1).FormulaR1C1 = "=RC[3]+RC[4]"
  
    Sheet1.Cells(1, 3).FormulaR1C1 = "=MyCalc(RC[-1],RC[-2])"
  
End Sub

Public Function MyCalc(Metric1 As Integer, Metric2 As Integer) As Integer

    MyCalc = Metric1 + Metric2
  
End Function

What I don't understand is why does this line of code:

    Sheet1.Cells(1, 1).FormulaR1C1 = "=RC[3]+RC[4]"

trigger the udf?

Is it because the udf takes two arguments, which are A1 and B1, so changing A1 and / or B1 triggers the udf?

Thanks

 

[RoryA]

Yes, assuming you already had that formula on the sheet.

 

[tiredofit]

Yes, assuming you already had that formula on the sheet.ys

yes, thanks