Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Function wizard for User Defined Functions
I am writing a user defined function to calculate commissions for sales
associates in my company. I need a way to provide documentation with this function. I'd like to use the Insert Function wizard to provide a definition of the parameters like you see for built-in functions. I've searched these forums for an answer to this question and I've found one thread answering a similar question from Fredrik Wahlgren that mentions creating chm files and linking them to the function using .idl files, but it seems to be specific to C++. I'm a C++ challenged visual basic.NET deveolper. Is there any way to use VBA or VB.NET to link a .chm file to a user defined function? Is there an easier way to accomplish this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Function wizard for User Defined Functions
Laurent Longre provides a utility to do this, but it requires distributing a
DLL if you share the function with other users. http://longre.free.fr/ -- HTH RP (remove nothere from the email address if mailing direct) "NBC" wrote in message ... I am writing a user defined function to calculate commissions for sales associates in my company. I need a way to provide documentation with this function. I'd like to use the Insert Function wizard to provide a definition of the parameters like you see for built-in functions. I've searched these forums for an answer to this question and I've found one thread answering a similar question from Fredrik Wahlgren that mentions creating chm files and linking them to the function using .idl files, but it seems to be specific to C++. I'm a C++ challenged visual basic.NET deveolper. Is there any way to use VBA or VB.NET to link a .chm file to a user defined function? Is there an easier way to accomplish this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Function wizard for User Defined Functions
Thanks for the URL, Bob. Looks like Longre's tool will do the job until I
become more C++ literate myself... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i cant see my user defined functions in function list | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions | |||
User functions and the Insert-Function dialogue | Excel Programming | |||
excel functions and User defined functions | Excel Programming | |||
Comining lots of functions into one User defined function | Excel Programming |