Help for Excel UDF & its Parameters

J

Jck

I got an Excel UDF (User Defined Function) with parameters.
I wonder how to add & edit help for it and its parameters, so that it can be
used like other Excel build in functions?
 
J

Jck

Just find it from Microsoft KB285337, "there is no way to specify function
descriptions, argument descriptions, or help for Automation Add-in functions
in the Function Wizard." (http://support.microsoft.com/kb/285337)
Look like there is no simple way to add & edit help for UDF and its parameter.

Anyway, thanks for the help!!
 
N

NickHK

If you are talking about a normal UDF then my link shows you how.
Not sure with COM add-ins.

NickHK
 
G

Gord Dibben

Jck

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

UNFORTUNATELY................Ballon/Screen Tips are not available with Laurent's
method.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top