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:

The Insert function dialog showing a custom category
Custom category created by technique described in the article

The Function wizard showing argument descriptions
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