Registering a User Defined Function with Excel

This article describes a method to register one's UDF with Excel so it shows up in a category of your choice, with argument descriptions as well:

Custom category created by technique described in the article

Argument descriptions created by technique described in the article

Click here to download the sample file.

Content:

Table ofContents

1. Introduction
2. How does it work?
3. Setting things up
4. Class Module
5. VBA code
6. Put to Use
7. Wrap Up

Frequently asked Questions