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

Rodrigo Ferreira

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" wrote:

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

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

"Jim May" escreveu na mensagem
...
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" wrote:

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

Rodrigo Ferreira

Rodrigo

You can add a brief description of your UDF by going to ToolsMacroMacros.

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

On Tue, 19 Sep 2006 16:02:25 -0300, "Rodrigo Ferreira"
wrote:

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

Rodrigo Ferreira


Gord Dibben MS Excel MVP