User functions and the Insert-Function dialogue

  • Thread starter Thread starter Tony Seiscons
  • Start date Start date
T

Tony Seiscons

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Defined Function 5
Multiple User Defined Categories in Insert Function Form 2
Add a category to the Insert-Function category list 1
How do I add a function category 1
Tabname function 1
Modify Function Category Names and Contents 1
To SQL Expert: VBA Function that Calls SQL Query 3
excel spreadsheet functions written in vba 1

Back
Top