function in Macro always return zero

[genie_0582]

Hi,

I could not find a thread that talk about this problem, and i do hope there is a solution. I write a very simple Public Function as follow

Public Function y (x As Single) As Single

y=x+5

End Function

When i try it, it gives 0.
When i try it again, it gives the correct answer.

seems like it's not stable.

 

[Scott Huish]

It works for me. How are you calling the function?

Although I gotta ask why are you writing a UDF to just add 5 to a number?

 

[genie_0582]

:D haha. thanks for solving my problem. This function is just to test whether it works or not. Nothing particular in this function. Anyway, I post it here and i figured it out by myself. For Excel 2011, we have to save the file, so that we can use the function.