Displaying help in a UDF

[JulieD]

Hi All

been playing with UDF's and would like to know how to display help info on
the UDF wizard screen ... where it says "no help available"
--
Cheers
JulieD

[dominicb]

Good evening JulieD

First of all you need to put the function into a category, because (and I think I'm right in saying this) you can't apply text to something in the user defined section.

Application.MacroOptions Macro:="MyUDF", Category:=x

where x =

0 All
1 Financial
2 Date & Time
3 Math & Trig
4 Statistical
5 Lookup & Reference
6 Database
7 Text
8 Logical
9 Information
14 User Defined

You can then put in your description in one of two ways:

VBA:
Application.MacroOptions Macro:="MyUDF", Description:="This is my UDF"

or do it from your workbook thus:
Tools > Macros > Macro and type the name of your function in the box and click on Options and put your description in the box that appears.

You only have to do this once, not every time the workbook opens.

Hope that's just what you wanted. Keep up the great work.

DominicB