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.
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.