View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
TKS_Mark TKS_Mark is offline
external usenet poster
 
Posts: 68
Default Public Function Description

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.