Put help/description in formulas (XLA)

R

Rodrigo Ferreira

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

Rodrigo Ferreira
 
J

Jim May

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
 
R

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
 
G

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
Click to expand...

Gord Dibben MS Excel MVP
 
Top