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?

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?

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...