I remember there was a simple way to put a sentence or two into the "function
arguments" box that comes up when you click fx while typing a public function
in Excel. There was something you could right-click and it doesn't show up
in the code. Does anyone remember how to do that?

For example, if you type =sumif( into a cell and then click the fx button,
you can see "Adds cells specified by a given condition or criteria". There's
a way to update that info.

Thanks.

Alt + F11 to open VBE

ViewObject Browser to get list of your User Defined Functions

Right-click on Function name and select Properties.

Type a description into the appropriate dialog.

Excel's built-in functions cannot be changed AFAIK


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, TKS_Mark
wrote:

I remember there was a simple way to put a sentence or two into the "function
arguments" box that comes up when you click fx while typing a public function
in Excel. There was something you could right-click and it doesn't show up
in the code. Does anyone remember how to do that?

For example, if you type =sumif( into a cell and then click the fx button,
you can see "Adds cells specified by a given condition or criteria". There's
a way to update that info.

Thanks.

Excellent. That's just what I was looking for!

"Gord Dibben" wrote:

Alt + F11 to open VBE

ViewObject Browser to get list of your User Defined Functions

Right-click on Function name and select Properties.

Type a description into the appropriate dialog.

Excel's built-in functions cannot be changed AFAIK


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, TKS_Mark
wrote:

I remember there was a simple way to put a sentence or two into the "function
arguments" box that comes up when you click fx while typing a public function
in Excel. There was something you could right-click and it doesn't show up
in the code. Does anyone remember how to do that?

For example, if you type =sumif( into a cell and then click the fx button,
you can see "Adds cells specified by a given condition or criteria". There's
a way to update that info.

Thanks.

I have already found that dialog but am having mixed success in entering the
text. the members options dialog allows you to type in your description but
it will not retain that script. Any secret tips?

TIA

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"TKS_Mark" wrote:

Excellent. That's just what I was looking for!

"Gord Dibben" wrote:

Alt + F11 to open VBE

ViewObject Browser to get list of your User Defined Functions

Right-click on Function name and select Properties.

Type a description into the appropriate dialog.

Excel's built-in functions cannot be changed AFAIK


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, TKS_Mark
wrote:

I remember there was a simple way to put a sentence or two into the "function
arguments" box that comes up when you click fx while typing a public function
in Excel. There was something you could right-click and it doesn't show up
in the code. Does anyone remember how to do that?

For example, if you type =sumif( into a cell and then click the fx button,
you can see "Adds cells specified by a given condition or criteria". There's
a way to update that info.

Thanks.

Ok, I guess I found it an thought all was good, but I can't get it to retain
the typed info either. Gord Dibben, do you know the trick?

Thanks.

"K_Macd" wrote:

I have already found that dialog but am having mixed success in entering the
text. the members options dialog allows you to type in your description but
it will not retain that script. Any secret tips?

TIA

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"TKS_Mark" wrote:

Excellent. That's just what I was looking for!

"Gord Dibben" wrote:

Alt + F11 to open VBE

ViewObject Browser to get list of your User Defined Functions

Right-click on Function name and select Properties.

Type a description into the appropriate dialog.

Excel's built-in functions cannot be changed AFAIK


Gord Dibben MS Excel MVP

On Thu, 6 Aug 2009 08:47:01 -0700, TKS_Mark
wrote:

I remember there was a simple way to put a sentence or two into the "function
arguments" box that comes up when you click fx while typing a public function
in Excel. There was something you could right-click and it doesn't show up
in the code. Does anyone remember how to do that?

For example, if you type =sumif( into a cell and then click the fx button,
you can see "Adds cells specified by a given condition or criteria". There's
a way to update that info.

Thanks.