Creating "Help files" for use with User Defined Functions

[dicktimmerman]

Hi,

I'm writing some hopefully usefull "UDF's" for engineering purposes.
As far as only I'm working with these functions, I'll be able to fill in the correct things, however, if somebody else would use the functions, he wouldn't know where to start.
I've noticed that if you "right click" on the project naem in the project browser, you'll find the option "Properties" a screen is shown with "Help-Filename" where you can enter a file with the ".HLP" extension.
Anyone who knows how to create such a file and how it should be formatted to let excel read this file?

 

[JGordon11]

You can add some modest help information that will appear in the Function Arguments dialog box that appears when you click on fx button.

example

Option Explicit

Sub AddDiscription()
    Application.MacroOptions Macro:="TestFunction", _
    Description:="Test Function adds up to three numerical parameters" _
    & vbCrLf & "a = first input (0 if not supplied)" _
    & vbCrLf & "b = second input (0 if not supplied)" _
    & vbCrLf & "c = third input (0 if not supplied)"
End Sub

Public Function TestFunction(Optional a As Variant = 0, Optional b As Variant = 0, Optional c As Variant = 0) As Double
    TestFunction = a + b + c
End Function

 

[Fluff]

You can also do it manually. Have a look here Excel: Adding Description to Custom Excel Functions

 

[dicktimmerman]

Is it depending on whether you use Office 365 or not?
Copypasted JGordon11's code to try out, nothing happened.

Also Fluff his suggestion isn't working in my version. I can Add text but when OK is clicked, all seems to disappear.


Edit: Probably did something wrong, JGordon11's solution shows some text.

 

[Fluff]

Is it depending on whether you use Office 365 or not?

No, you have been able to add descriptions for a long time.