User defined Spreasheet Functions - How to add "help/ assistance comments"

[Adrian]

I would greatly appreciate some advice with the following:


I am defining some "user defined spreadsheet functions" of
my own. How can I include some "on-line" help comments to
be displayed when the user will be using the new
functions, the same way the built-in Excel functions are
set up. For example, when LOOKUP() function starts, the
comment: "Returns a value from a one-row or a one-column
range of an array" is displayed. Every time the user
clicks on a parameter field, the relevent comment is
displayed, for example for Lookup_value: "Lookup_value is
a value that LOOKUP searches in...," etc.


I have tried to access the member properties in Object
Browser, and include a comment in the description field
for my function. However when I hit OK and re-open, my
comment is not saved...

Thank you in advance,

Adrian

 

[Bernie Deitrick]

Adrian,

Choose Tools | Macro | Macros... then type the function name into the box
(it won't be a choice because it's not a macro: you may need to include the
workbook name like "Personal.xls!IsPrime" or even the module name like
"Personal.xls!PrimeModule.IsPrime", depending on where the function is) and
then click on the Option button and type your description in the box. Close
the dialog, then save your file, and it will remain with the function. Note
that
you will not be able to give parameter by parameter descriptions such as
Excel offers for its built-in functions.

HTH,
Bernie
MS Excel MVP

 

[Adrian]

Thanks a lot Bernie,

It worked exactly as you said!

Adrian Florea
PWGSC (Canada)