How do I add help text to an excel function I have created

[Peter 99]

I have some functions in Excel (created in version 4) that don't have any
help text i.e. don't give a description of what the function does. How can I
add help text to these functions

 

[Norman Jones]

I have some functions in Excel (created in version 4) that don't have any
help text i.e. don't give a description of what the function does. How
can I
add help text to these functions

Hi Peter,

This is not natively supported in Excel but you may like to look at Laurent
Longre's Funcustomize add-in which is freely downloadable at:

http://longre.free.fr/english/

 

[Gord Dibben]

You can add a brief description(not arguments) if you open the VBEditor and
View>Object Browser.

Find your UDF and right-click and you can add a comment there.

Otherwise follow Bob's pointer.

Gord Dibben Excel MVP