On 2002-10-09 22:20, Swamp Thing wrote:
If I understand the original post, the idea was to make the help available directly in the "paste function" dialog box (function wizard). The user would click on the question mark button and then click on "help on this function" ... and voila, up pops a help box for the UDF. In other words the UDF help would be accessed just as one looks for help on built-in functions like VLOOKUP or SUMIF etc.
To achieve this, the path to the help file has to be specified in the VB editor:-
Tools > Project Properties > [enter help file name ]
If your help file contains many bits of information, then you can assign a help context ID to each one. [of course you would do this using one of the many help file tools that we have been discussing]
Then, in the Object Browser, you locate your UDF and right click to see its properties. You can enter the relevant help context ID.
Now when you are looking at the function through the function wizard, the UDF help will pop up if you click on the question mark and request 'help on selected function'.
IIRC, this help will also pop up in VBE when the cursor is on the function name and you click F1.
Finally, if you are using later versions of windows, you can just use a plain vanilla html file instead of .hlp or .chm
This message was edited by Swamp Thing on 2002-10-09 22:28