User Defined Functions in DIFFERENT CATEGORIES

Prosenjit Banerjee · Apr 8th, 2002, 01:00 AM

Sir,
I want to make macros (i.e. public fuctions/subs) which I want to be appeared in the list of the Excel's "Paste Function" dialog box.
But, please wait, I know that if the functions/subs are declared as "public" then these are automatically appeared in the "User Defined" function category. But I want them to be appeared in other categories [such as "Text", "Financial", "Math & Trig" etc.]. I have seen an addin-in which makes it's functions available in different categories.
How can I do it? Please help me.

Dave Hawley · Apr 8th, 2002, 03:03 AM

Hello

Try my Web page here, it describes this and more:

http://www.ozgrid.com/VBA/DesciptionToUDF.htm

Prosenjit Banerjee · Apr 8th, 2002, 11:59 PM

Dear Mr. Dave,
Thanks very much for all your tips found in your web site. They are really helpful. Thank you very much again.

Sir, I want to receive the newslatters from your side. How can I receive those? You publish you newletter on 10th of every month. Today is 9th. So, I want to immediately join receive your newsletters.

Dave Hawley · Apr 9th, 2002, 03:53 AM

Hi Prosenjit

If you have not already done so, go here and enter your email.

http://www.ozgrid.com/News/default.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 01:00 AM	#1
Prosenjit Banerjee New Member Join Date: Mar 2002 Location: India Posts: 19	Sir, I want to make macros (i.e. public fuctions/subs) which I want to be appeared in the list of the Excel's "Paste Function" dialog box. But, please wait, I know that if the functions/subs are declared as "public" then these are automatically appeared in the "User Defined" function category. But I want them to be appeared in other categories [such as "Text", "Financial", "Math & Trig" etc.]. I have seen an addin-in which makes it's functions available in different categories. How can I do it? Please help me.

Apr 8th, 2002, 03:03 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hello Try my Web page here, it describes this and more: http://www.ozgrid.com/VBA/DesciptionToUDF.htm

Apr 8th, 2002, 11:59 PM	#3
Prosenjit Banerjee New Member Join Date: Mar 2002 Location: India Posts: 19	Dear Mr. Dave, Thanks very much for all your tips found in your web site. They are really helpful. Thank you very much again. Sir, I want to receive the newslatters from your side. How can I receive those? You publish you newletter on 10th of every month. Today is 9th. So, I want to immediately join receive your newsletters.

Apr 9th, 2002, 03:53 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Prosenjit If you have not already done so, go here and enter your email. http://www.ozgrid.com/News/default.htm