Insert description into own Formulas

[Guest]

Is it possible to add text in the formula wizard area to explain the formula
which we have created ourselves? For all the other standard formula there is
a description but how can I insert a description into the dialog box for the
formula we have created?

Kind regards

Nicole

 

[Carim]

Hi Nicole,

Using Range names could make the formula self descriptive i.e.
Profit = (Puchases*1.3) - Expenses
and you could insert comment to describe your formula ...

HTH
Cheers
Carim

 

[Gord Dibben]

Nicole

You can use this type of formula

=a2*a1+n("my wage+bonus-4 weekly loan repayments")

Anything after the "n" will be seen in the formula bar but not in the cell.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

ooops!

Perhaps you are talking about description for a User Defined Function you
created.

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

Type in the name of your UDF and hit "Options". Add a description and hit OK
then Cancel. Yes......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

Is it possible to add text in the formula wizard area to explain the formula
which we have created ourselves? For all the other standard formula there is
a description but how can I insert a description into the dialog box for the
formula we have created?

Kind regards

Nicole

Gord Dibben MS Excel MVP

 

[David Biddulph]

Is it possible to add text in the formula wizard area to explain the
formula
which we have created ourselves? For all the other standard formula there
is
a description but how can I insert a description into the dialog box for
the
formula we have created?

You can insert a comment in the cell where the formula is.

 

[Guest]

Yes, I did mean the description for a user defined function...many thanks for
all the hints...I will test them!

 

[Guest]

In the VBA editor, enter that line in the "Immediate" window:
Application.MacroOptions
"NAME_OF_YOUR_FORMULA","THE_DESCRIPTION_YOU_WANT_TO_ASSIGN_TO_YOUR_FORMULA"