Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Adding my own function category in Excel

Posted on 1998-01-09
1
Medium Priority
?
279 Views
Last Modified: 2009-07-29
I have created my own Excel add-in, Analytic.xla. When I add it in to Excel 7 via Tools..Add-in, functions contained within the add-in are added to the User Defined function category when viewed through function wizard. Is there a way of creating my own function category under which those functions within the add-in would appear, rather than always appearing under User Defined category? For example, if I had function called MySum within the add-in, when function wizard is run it would show all usual function categories (Mathematical, Statistical, etc.), my own category (say, e.g. MyCategory), AND User Defined category. The MySum function could then be found, of course, only under MyCategory category.
0
Comment
Question by:pb1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
itamar earned 800 total points
ID: 1607385
Hi pb1, I am also working on it. The following article was extracted from Microsoft knowLedge Database and worked fine for me. Place a comment if you still have some doubts:

>>>
XL: How to Add a New Category to Function Category List

    Last reviewed: September 2, 1997
    Article ID: Q137526
    The information in this article applies to:

        Microsoft Excel for Windows, versions 5.0, 5.0c
        Microsoft Excel for the Macintosh, version 5.0
        Microsoft Excel for Windows NT, version 5.0
        Microsoft Excel for Windows 95, version 7.0
        Microsoft Excel 97 for Windows

    SUMMARY

    To manually create a custom category for a user-defined function that you write in Visual Basic for Applications, you
    must insert a Microsoft Excel 4.0 macro sheet before you create the category.

    MORE INFORMATION

    To create a custom category, use the following steps:

      1.In Microsoft Excel 97, right-click a sheet tab in the workbook and click Insert. Click MS Excel 4.0 Macro and
        click OK to add a macro sheet to the workbook.

        In Microsoft Excel 5.0 and 7.0, point to Macro on the Insert menu, and click MS Excel 4.0 Macro to add a
        macro sheet to the workbook.

      2.On the Insert menu, point to Name, and then click Define. Under Macro, click Function.

      3.In the Name box, type "TEST1" (without the quotation marks).

      4.In the Category box, replace "User Defined" with the new category "(type the choosen Name)[Itamar]", and then click OK.

    Microsoft Excel adds the new category to the list. After you add one or more custom
    functions to the new category, you can delete the "TEST1" function name. When you do
    this the new category remains. If you delete the Microsoft Excel 4.0 macro sheet, functions
    already assigned to the custom category remain in that category; however, you cannot
    assign a new function to that category after you delete the macro sheet.

    Adding a Function to a Specific Category in Microsoft Excel 97

    In Microsoft Excel 97, you cannot add a user-defined function to a specific category by selecting the function in a
    dialog box. You must use a macro to specify a category for the function. For additional information, please see the
    following article in the Microsoft Knowledge Base:

       ARTICLE-ID:  Q157108
       TITLE     :  Options not Available in Macro Options Dialog Box


    Adding a Function to a Specific Category in Microsoft Excel 5.0 and 7.0

    To specify a category for a user-defined function, use the following steps:

      1.With a module sheet active, press F2 to start the Object Browser

      2.Select the workbook in the Libraries/Workbooks list.

      3.Select the custom function in the Methods/Properties list and click Options.

      4.Select the category in the Function Category list and click OK.

      5.Click Close to close the Object Browser.

    REFERENCES

    "User's Guide 2," version 4.0, Chapter 5, "To Name a custom function," page 210

    For additional information, please see the following article(s) in the Microsoft Knowledge Base:

         ARTICLE-ID: Q141825
         TITLE     : How to Add a New Category to Function Category List

Let me know your results.
Regards,
Itamar
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question