[RESOLVED] Excel 97 User defined function?

[Guru]

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

[Shuja Ali]

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

=xx()

[Guru]

Yay! Thanks