Help file for VBA custom function
 

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

Help file for VBA custom function
 

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

--
isabelle