Text parameters are STRING variables
e.g.

DIM mytext as string

HTH

"Jocken" wrote:

I'm trying to create a custom function in excel 2007 using visual basic. The
parameter type seems to default to numeric and I cannot figure out the syntax
to specify text parameters. The example custom function in help only uses
text parameters. I've gotten my function to compile, but using it results in
a #VALUE!.