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?

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?

Sorry, Tom, for maybe not being more specific. When you start entering a
function, let's say "=PV(" on the worksheet, the arguments show on the screen
and the argument you are entering is highlighted in bold. That is what I was
talking about being able to code with a custom function. I know that the
Insert Function menu choice will show the choices but I would rather be able
to code the other prompts. Do you know any way of doing that?

Thanks.

Kevin

"Tom Ogilvy" wrote:

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?

For this functionality with a User Defined function built in VBA, I don't
believe there are any options you can use to force excel to behave other
than it does.

--
Regards,
Tom Ogilvy


"dunnerca" wrote in message
...
Sorry, Tom, for maybe not being more specific. When you start entering a
function, let's say "=PV(" on the worksheet, the arguments show on the
screen
and the argument you are entering is highlighted in bold. That is what I
was
talking about being able to code with a custom function. I know that the
Insert Function menu choice will show the choices but I would rather be
able
to code the other prompts. Do you know any way of doing that?

Thanks.

Kevin

"Tom Ogilvy" wrote:

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?