Insert description into own Formulas

N

Nicole

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
 
C

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
 
G

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
 
G

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

Gord Dibben MS Excel MVP
 
D

David Biddulph

Nicole said:
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?
Click to expand...

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

Nicole

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

PapaDos

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"
 
Top