Microsoft Office Tutorials and References
In Depth Information
Figure 24-5: Executing a VBA statement that assigns a function to a particular function category.
After you execute the procedure, you can delete it. A function can be assigned to only one category. The last
category assignment replaces the previous category assignment (if any).
You will, of course, substitute the actual name of your function, and you can specify a different function cat-
egory. The AssignToFunctionCategory procedure can contain any number of statements — one for each of your
Table 24-1 lists the function category numbers that you can use. Notice that a few of these categories (10–13)
normally don't display in the Insert Function dialog box. If you assign your function to one of these categories,
the category then appears.
You can also create custom function categories. The statement that follows creates a new function category
named My VBA Functions and assigns the REMOVESPACES function to this category:
Application.MacroOptions Macro:=”REMOVESPACES”, Category:=”My VBA
Table 24-1: Function Categories
All (no specific category)