Put help/description in formulas (XLA)

[Rodrigo Ferreira]

How can I put description/help (like excel's formulas) in my functions and
his parameters (XLA)?

Rodrigo Ferreira

 

[Guest]

In Cell A1:A3 enter 234, 345, 456
In Cell A4 enter:

=SUM(A1:A3)+N("This is a test")

A4 - should display 1,035 only.

Is this what you mean?
HTH

 

[Rodrigo Ferreira]

No.
I create a function: "MyTest(strCell1, strCell2)"
When I try to use this function, when open the "function wizard", I would
like to see a description of the function "MyTest" and the description of
the parameters of strCell1 and strCell2

Rodrigo Ferreira

 

[Gord Dibben]

Rodrigo

You can add a brief description of your UDF by going to Tools>Macro>Macros.

Type in the name of your UDF and "Options". Add a description and hit OK then
Cancel.

To actually add the arguments you will need something more complex.

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

How can I put description/help (like excel's formulas) in my functions and
his parameters (XLA)?

Rodrigo Ferreira

Gord Dibben MS Excel MVP