Help file for VBA custom function

[Domagoj]

Hi to all, if someone can post the link or some other reference how to make help
file for VBA custom function (MS Excel).
For example, if I made Function CelsiusToFahrenheit - in spreadsheet, when someone
click on function icon to enter the formula, built in functions can have help file,
but i didn't found how to attach help file for my own, custom function
thanx

 

[isabelle]

hi,

MacroOptions, méthode
but this functionality appears to be not operational in excel2007.



Sub Test()
Application.MacroOptions Macro:="MyFunction", Category:=7, _
Description:="short description", _
HelpFile:="C:\MyHelpFunction.CHM", _
HelpContextID:=4050
End Sub


0 No category appears only in All
1 Financial
2 Date & Time
3 Math & Trig
4 Statistical
5 Lookup & Reference
6 Database
7 Text
8 Logical
9 Information
10 Commands normally hidden
11 Customizing normally hidden
12 Macro Control normally hidden
13 DDE/External normally hidden
14 User Defined default
15 Engineering

 

[Gord Dibben]

Not a help file, but some notes on the UDF.

2003 and earlier.........Tools>Macro>Macros

Type in the name of your UDF and hit "Options"

Under "Description" type in a brief note about your UDF then hit OK and Cancel

I think you can enter 255 characters(including spaces)

Something fancier would involve Laurent Longre's assistance.

See http://xcell05.free.fr/english/ for his FUNCUSTOMISE.DLL free download.


Gord Dibben MS Excel MVP