Microsoft Office Tutorials and References
In Depth Information
Dealing with the Insert Function Dialog Box
Figure 10-11: The Insert Function and Function Arguments dialog boxes for a custom function.
Specifying a function category
If you don’t use the MacroOptions method to specify a different category, your custom
worksheet functions appear in the User Defined category in the Insert Function dialog box. You may
prefer to assign your function to a different category. Assigning a function to a category also
causes it to appear in the drop-down controls in the Formulas➜Function Library group on the
Ribbon.
Table 10-1 lists the category numbers that you can use for the Category argument for the
MacroOptions method. Notice that a few of these categories (10 through 13) aren’t normally
displayed in the Insert Function dialog box. If you assign your function to one of these categories,
the category will appear in the dialog box.
Table 10-1: Function Categories
Category Number
Category Name
0
All (no specific category)
1
Financial
2
Date & Time
3
Math & Trig
4
Statistical
5
Lookup & Reference
6
Database
7
Text
8
Logical
9
Information
continued
 
Search JabSto ::




Custom Search