[RESOLVED] Excel 97 User defined function?

in the VB editor on Sheet1 I've put this code:

Function xx()
xx = "hello"
End Function


in a cell on sheet one I've got

=Sheet1.xx()


I selected this from the insert -> function -> user defined list
and I get an error saying that the name isn't valid

WHY?



Thanks

You cannot put a User Defined function in the Sheet (in the code view). Put the function in a Module. Go to the Code view and INsert a module. Then write your function. THen you could use it like this

Code:

---

=xx()

---

Yay! Thanks

:thumb: