function calls

  • Thread starter Thread starter Claude
  • Start date Start date
C

Claude

Hi all

What is the logic behind the number of times a function is
called? A simple example to illustrate:

Function add(a, b)
MsgBox ("add")
add = a + b
End Function

In the worksheet I have:
A1: 1
A2: 2
A3: =add(A1;A2)

If I change the value in cell A1, the function runs 3
times. Why? Is it possible to force a certain function to
run only once?
 
Only runs once for me.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Just realised my file had a reference to an external
object library. Looks like this was messing things up.
Thanks for helping me further!
 
Back
Top