Public Function Description

  • Thread starter Thread starter TKS_Mark
  • Start date Start date
T

TKS_Mark

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

View>Object 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
 
Excellent. That's just what I was looking for!

Gord Dibben said:
Alt + F11 to open VBE

View>Object 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
Click to expand...
 
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
 
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.
 
Back
Top