Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Defined Functions | Excel Worksheet Functions | |||
help text for user defined formula | Excel Worksheet Functions | |||
User defined functions without using VBA. | New Users to Excel | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
User defined functions without using VBA. | Excel Worksheet Functions |