View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Adding hints to my vb functions

On Sat, 07 Mar 2009 10:02:22 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

You can also do this manually.

With your UDF workbook open got to VBE, select your workbook/project and
ViewObject Browser

Right-click on the UDF name and under Properties you can type a description.

Will show up after saving the workbook/project.


Gord,

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.

The MacroOptions mentioned by Rick seems to not only work, but, after running,
the description will be in the properties dialog box for my add-in.
--ron