Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
NBC NBC is offline
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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   Report Post  
Posted to microsoft.public.excel.programming
NBC NBC is offline
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
i cant see my user defined functions in function list delmac Excel Worksheet Functions 1 August 11th 06 10:23 AM
User Defined Functions Frank@shell Excel Worksheet Functions 3 April 20th 05 02:41 PM
User functions and the Insert-Function dialogue Tony Seiscons Excel Programming 1 September 22nd 04 02:02 PM
excel functions and User defined functions Kanan Excel Programming 4 May 20th 04 11:21 PM
Comining lots of functions into one User defined function ksnapp Excel Programming 0 January 7th 04 10:51 PM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"