A Question on User Defined Functions.

[ajames54]

I've written a number of functions for the group I
support here at work, and we want to share them through out the
rest of the firm...

If that is going to happen I will want to include the
field definitions in the formula pallet.. how can I code this?


(I really don't want to have to answer the same questions over
and over again ...)

 

[Robin Hammond]

Laurent Longre has something quite complex on his site that tries to address
this, but I have never got it to work. I'd say the realistic answer is that
you cannot do
it reliably, so name the parameters as obviously as you can. If you are
distributing as an add-in, you could create a custom menu with your
functions on. There's a trick on how to launch the InsertFunction dialog
with your UDF in it from a menu on my site here:
http://www.enhanceddatasystems.com/ED/Pages/ExcelInsertUDF.htm

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

 

[ajames54]

Laurent Longre has something quite complex on his site that tries to address
this, but I have never got it to work. I'd say the realistic answer is that
you cannot do
it reliably, so name the parameters as obviously as you can. If you are
distributing as an add-in, you could create a custom menu with your
functions on. There's a trick on how to launch the InsertFunction dialog
with your UDF in it from a menu on my site here:
http://www.enhanceddatasystems.com/ED/Pages/ExcelInsertUDF.htm

Robin Hammond
www.enhanceddatasystems.com
Check out our XspandXL add-in

Thanks ... looks like obvious names and a big help file will have
to do..