Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
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
User Defined Functions CH Excel Worksheet Functions 4 September 22nd 08 10:16 AM
help text for user defined formula WJvR Excel Worksheet Functions 2 July 23rd 08 04:34 PM
User defined functions without using VBA. [email protected] New Users to Excel 0 June 13th 06 05:55 PM
User defined functions without using VBA. [email protected] Excel Worksheet Functions 0 June 13th 06 05:49 PM
User defined functions without using VBA. [email protected] Excel Worksheet Functions 0 June 13th 06 05:44 PM


All times are GMT +1. The time now is 02:15 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"