VBA description of function

  • Thread starter Thread starter Urban
  • Start date Start date
U

Urban

How do I insert or edit the description of a Function that
I have created? In VBA I open the Object Browser, and find
my function VBAProject -Module1 - NameXYZ.. I then right
click and select Properties. The Window that opens is
called Member Options, in the Description box I can type
my text but I doesn't stick. What do I do wrong?

Thanks for the help, Urban
 
Urban

You're in the right place and following the proper steps to that point.

Try saving/closing then re-opening the file before testing the Function on a
worksheet.

Your description should be retained.

The FUNCUSTOMIZE that Frank pointed you to is better. It also allows you to
add the arguments as well as a description.

Gord Dibben Excel MVP
 
Back
Top