Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
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 On Thu, 5 Oct 2006 10:09:02 -0700, Nicole wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
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 ToolsMacroMacros. 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 On Thu, 5 Oct 2006 10:09:02 -0700, Nicole wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
"Nicole" wrote in message
... 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. -- David Biddulph |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
Yes, I did mean the description for a user defined function...many thanks for
all the hints...I will test them! "Gord Dibben" wrote: 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 ToolsMacroMacros. 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 On Thu, 5 Oct 2006 10:09:02 -0700, Nicole wrote: 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert description into own Formulas
In the VBA editor, enter that line in the "Immediate" window:
Application.MacroOptions "NAME_OF_YOUR_FORMULA","THE_DESCRIPTION_YOU_WANT_T O_ASSIGN_TO_YOUR_FORMULA" -- Festina Lente "Nicole" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate cells | Excel Discussion (Misc queries) | |||
Please help with Statistics Formulas in Excel | Excel Discussion (Misc queries) | |||
insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
Inserting Columns and Formulas updating | Excel Worksheet Functions | |||
INSERT ROWS WITHOUT SCREWING-UP FORMULAS! | Excel Worksheet Functions |