User functions and the Insert-Function dialogue
 

I note that the Excel Insert-Function dialogue picks up public functions
that I create so that I can be prompted for the function parameters. This is
useful as I, like many others I suspect, tend to forget how to use the UDF's
I create. There is no help with this of course and no calculated result
however I noticed that an Add-in I was testing a few weeks ago managed to
get a separate entry in the Category drop-down list in Insert-Function and
help for the function display just like the built in Excel functions. I
have recently been researching the creation so HTML help files and have
noted techniques for providing help for Class modules but I haven't come
across anything about this. Does anyone have any idea how this is done or
if it is a complex problem know where on the Net I can find information
about it.
Tony

User functions and the Insert-Function dialogue
 

I have discovered that the VBA procedure Application.MacroOptions allows the
description of the function to be modified and a help ID to be attached.
"Tony Seiscons" wrote in message
...
I note that the Excel Insert-Function dialogue picks up public functions
that I create so that I can be prompted for the function parameters. This
is
useful as I, like many others I suspect, tend to forget how to use the
UDF's
I create. There is no help with this of course and no calculated result
however I noticed that an Add-in I was testing a few weeks ago managed to
get a separate entry in the Category drop-down list in Insert-Function and
help for the function display just like the built in Excel functions. I
have recently been researching the creation so HTML help files and have
noted techniques for providing help for Class modules but I haven't come
across anything about this. Does anyone have any idea how this is done or
if it is a complex problem know where on the Net I can find information
about it.
Tony