Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Question on User Defined Functions.
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 ...) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Question on User Defined Functions.
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 he http://www.enhanceddatasystems.com/E...lInsertUDF.htm Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "ajames54" wrote in message ... 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 ...) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Question on User Defined Functions.
On Wed, 8 Oct 2003 07:52:12 +0800, "Robin Hammond"
wrote: 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 he http://www.enhanceddatasystems.com/E...lInsertUDF.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.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions | Excel Discussion (Misc queries) | |||
User defined functions without using VBA. | Excel Discussion (Misc queries) | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
About User Defined Functions | Excel Worksheet Functions | |||
User Defined Functions | Excel Worksheet Functions |