Creating Help within functions

[Joe Carroll]

Hi All,

Was wondering if anyone can point me in the right direction wrt creating
help for my custom functions. Microsofts functions pop up with a little
description of the function on the input box, and often have a hyperlink to
a help file. How do I do the same with my functions?

Joe.

[Joe Carroll]

Anyone interested in a solution to this, the following was posted on the
microsoft.public.excel newsgroup by Dave Peters:
This won't work like the tips, but it will work if you use the function
wizard.

Tools|macro|macros...
type in the name of your function
(you won't be able to select it from the displayed list)

Click the Options button
There's a small textbox where you can type in a short description for that
function.
Click the ok button
then click the cancel button (to dismiss that dialog)

And it could be very helpful if you use nice names for the parms that are
being
passed to the function. This would help if the user hits ctrl-shift-a while
entering the formula.

ps. You can use ctrl-a to see the function wizard instead of using the
mouse
and clicking on that fx button.


"Joe Carroll" <joeInsertTheAtcarroll-acoustics.net.au> wrote in message
news:[email protected]...
> Hi All,
>
> Was wondering if anyone can point me in the right direction wrt creating
> help for my custom functions. Microsofts functions pop up with a little
> description of the function on the input box, and often have a hyperlink
> to a help file. How do I do the same with my functions?
>
> Joe.
>