User Defined Functions in DIFFERENT CATEGORIES
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: User Defined Functions in DIFFERENT CATEGORIES

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello

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

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

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Prosenjit


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

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com