Help file for VBA custom function

  • Thread starter Thread starter Domagoj
  • Start date Start date
D

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
 
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
 
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
 
Back
Top