User defined functions - text for formula palette
 

Public function MyFunction(arg1, arg2)



End Function

placed in a standard module (not a worksheet or thisworkbook module or class
module)
in an open workbook or an addin should appear in the formula palette.

http://support.microsoft.com/default...b;en-us;277017
XL2000: Cannot See User-Defined Function in the Paste Function Dialog Box

http://support.microsoft.com/default...b;EN-US;213645
XL2000: How to Use a Custom Function in Another Workbook

http://support.microsoft.com/default...b;en-us;142123
XL: How to Remove User-Defined Functions from Function Wizard

http://support.microsoft.com/default...b;en-us;151490
XL: How to Create a Global User-Defined Function

http://support.microsoft.com/default...b;en-us;213813
XL2000: How to Add a New Category to Function Category List

As far as assigning a help file to the macro, that is done in the
macrooptions method of the application.object. I haven't done it, so I
don't know if that will work with the help on this function button

http://support.microsoft.com/default...b;en-us;157108
XL97: Options Not Available in Macro Options Dialog Box

Regards,
Tom Ogilvy


"Steve Kite" wrote in message
om...
Is it possible to code in text to a user defined function which will
appear in teh formula palette when a user is entering the formula via
the paste function (fx button) method? If so, what is the syntax? How
do you create a link to a help file associated with the user defined
function that will be followed if the user clicks on the help button
in the formula palette?
Thanks