Public Function CustomFunctionName(a as string, b as Long, c as double, d as
string, e as long)

End sub

in a general module.

then if you do Insert function, it should be under "user defined" and boxes
provided by the dialog for each argument.


If you want help text for the arguments, see Laurent Longre's site for a
free addin that will give you support for this

http://xcell05.free.fr/
--
Regards,
Tom Ogilvy


"dunnerca" wrote in message
...
I have created a custom function with 5 possible arguments. Is there a
way
to have the "IntelliType" feature work with custom functions where the
user
is prompted for the list of required arguments for the function?