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

instead of just typing in =myfun("helloworld")

you should click in Insert Function, then select your function fro
the "All" list

--
Message posted from http://www.ExcelForum.com

Hi I cant see the function,
I want to call a function I have written!
not a standard excel function!
The all list only lists excel functions, where
should i define my vb function to appear in this ALL
list? i can see it!

HELP

-----Original Message-----
instead of just typing in =myfun("helloworld")

you should click in Insert Function, then select your
function from
the "All" list.


---
Message posted from http://www.ExcelForum.com/

.

Put it in a general module rather than a sheet module or the thisworkbook
module.

Make sure it isn't declared as private.

--
Regards,
Tom Ogilvy

"mike grasso" wrote in message
...
Hi I cant see the function,
I want to call a function I have written!
not a standard excel function!
The all list only lists excel functions, where
should i define my vb function to appear in this ALL
list? i can see it!

HELP

-----Original Message-----
instead of just typing in =myfun("helloworld")

you should click in Insert Function, then select your
function from
the "All" list.


---
Message posted from http://www.ExcelForum.com/

.