VBA Custom Function Question

[jk1]

Quick question that might help clear up some confusion for me. I'm using a custom function that I wrote that is not always updating. The function itself is pretty straight forward, but difficult to explain outside of the context of the file it is being used in. However, below is an example of how the spreadsheet is set up in a very simplified way.

Question is ... When I change cell A1, should B2 update?

My understanding is yes, but this the is only thing I can think of that would be causing my problem.

Thanks much in advance


Function Test(TestValue)
Test = TestValue * TestValue
End Function


Spreadsheet
A1: "5"
A2: "=A1"

B2: "=TestValue(A2)"

 

[shg]

Yes, the function should update when you change any precedent cell and calculation is set to automatic.

A common reason that UDFs don't update is because not all of their immediate precedents are passed as arguments, so Excel sees no dependency. That's not the case with your simple function, but that's not your real function.

A1 should contain the number 5, not the text "5", and the UDF should declare the type of argument it expects in the signature:

Function Test(TestValue As Double)