Category in which the function will appear within the Excel Formula Wizard
This property controls which category the function will appear under, in the Excel Formula Wizard.
The default value for Category is controlled by the XLL+ General Options setting DefaultCategory.
The standard built-in categories are stored as numbers between 1 and 14, but are displayed in XLL+ as they would appear in Excel. The standard categories are listed below with their US English names.
| Number | Name |
|---|---|
| 1 | Financial |
| 2 | Date & Time |
| 3 | Math & Trig |
| 4 | Statistical |
| 5 | Lookup & Reference |
| 6 | Database |
| 7 | Text |
| 8 | Logical |
| 9 | Information |
| 10 | Commands |
| 11 | Customizing |
| 12 | Macro Control |
| 13 | DDE/External |
| 14 | User Defined |