Creating Your Own Help screens

How do you write a help file for an Excel VBA function that is displayed when a user clicks "help on this function"

Depends largely on the size and or sophistication of the help. If it is short say a reasonable paraph, use comments.

Thanks.  Specifically, I mean through the Excel fx feature.  When you invoke fx, you get the list of arguments with entry fields, a description of the function, and the opportunity to select help for that function.  I haven't found any way to add the description and help.

Here's how you would do it:

1.  In the Visual Basic Editor, go to the menu bar and select View-->Object Browser.

2.  Click the drop-down list that contains the words "All Libraries" and select "VBAProject".  This will display your modules in the pane on the left. 

3.  Click the module or class that contains your User Defined Function.

4.  Right-click the name of your function and select Properties. 

This will open the Members Options dialog box, where you can enter your description and point to the correct Help context.

Hi Mike,

I'm not familiar with customising Help - from what I understand, your above 'how to' allows you to point the help for a UDF to an existing Help item (as defined by the Help Context number).

But how do I write my own help file? ...and then set context IDs with which to link my UDF to?

I see what you are saying now. 

 I'm frankly stumped on this one. I can't seem to make the Member Options dialog box accept an external help file.  I may be missing something, but I think you can only point to an internal context ID.

This blog post at Daily Dose of Excel talks a little about how to create some quick and dirty help files.  But again, I can't see a to point to them from the function wizard.

http://www.dailydoseofexcel.com/archives/2004/10/21/creating-help-files/