Hi

I have a function that i want ot use in a xcel formula?
can this be done
my function...
Public Function myfun(str As String) As String
myfun = "xxxx"
End Function

How do i call it from a cell
i tried in excel spreadsheet cell
=myfun("helloworld")
but this does not work is it possible?

thanks mike