Custom Function Tips

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dunnerca - 23 Jan 2006 21:21 GMT

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?

Reply to this Message

Tom Ogilvy - 23 Jan 2006 22:04 GMT

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/

Signature

Regards,
Tom Ogilvy

> 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?

Reply to this Message

dunnerca - 24 Jan 2006 13:35 GMT

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

> Public Function CustomFunctionName(a as string, b as Long, c as double, d as
> string, e as long)
[quoted text clipped - 15 lines]
> user
> > is prompted for the list of required arguments for the function?

Reply to this Message

Tom Ogilvy - 24 Jan 2006 14:13 GMT

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.

Signature

Regards,
Tom Ogilvy

> 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
[quoted text clipped - 26 lines]
> > user
> > > is prompted for the list of required arguments for the function?

Reply to this Message