View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Adding hints to my vb functions

When UDF's are in an Add-in..........................

In Excel go to ToolsMacroMacros, type in the UDF name and "Options"

Type the description and OK

Do for other UDF's

Hit Cancel key to leave Macros dialog when done with adding the
descriptions.

Save the add-in. Or Excel will ask next you close Excel.


Gord



On Sat, 07 Mar 2009 13:59:01 -0500, Ron Rosenfeld
wrote:

Although that method seems to work OK for a VBA project, I tried it with an
**add-in** and the description "doesn't take".

By that I mean if I right-click on the UDF name; enter something in the
Property dialog box; hit <OK. When I immediately re-open the property dialog
box, the entry is blank.