User Defined Functions in DIFFERENT CATEGORIES

Prosenjit Banerjee

New Member
Joined
Mar 19, 2002
Messages
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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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.
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top