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

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