Providing help information once you've made a function

[Mightyginger]

Firstly, lets say I've made a bunch of functions for use within a worksheet. How do provide some help text so that if they bring up the function there is a description with it also e.g if i click on the function button, select the function there is normally help provided by microsoft explaining what the function does.

Also, just out of interest, if I've made a bunch of functions and would like to make them available as an addin so I can just send someone an xla file and they can install them as an addin - whats the correct way of bundling up the functions or do I just need to save a blank excel sheet with the functions in the modules and name it .xla and then install it as an addin?

Many thanks for what are probably obvious question.


Neil.

 

[combo]

You have some possibilities to customize UDF functions. Assume that you still have standard xls file with macros:
- description. As you can see description in function wizard (but no argument description): go Tools>Macro>Macros.. (or ALT+F8). Write function's name, now you should have access to "options" button. Write your own description.
- category. As default, a separate category is reserved for UDF. However, you can assign it to any other using macro: Application.MacroOptions Macro:="Your_UDF_Name"...etc. (see excel VBA help for details). Using this you can also add description (instead of using ALT+F8), and reference to your own help file (I have not tested this option).
- additional help. There are many ways to do it. You can write your own help file. You can design a custom form with a combo box with list of functions and a textbox with function description. For few functions it can be a multipage. You can assogn a shortcut to macro displaying the dialog, add menu item or design your own toolbar.

Installation - it is enough to save excel file as an add-in and distribute it. However, the user has to manually install it. I've tried to automate installation via excel (thread707-595209), however it still requiers permission to enable macros.

combo

 

[Mightyginger]

thanks for your help matey.


Neil.