Add Description Text to a UDF in Excel

Note that this description text is only visible when you open the Function Arguments window by clicking the Insert Function (fx) button.

Steps to Add a Description to a UDF

1. Go to the VBA Editor window (Alt + F11) and make sure you have input the UDF.
   
2. Hit F2 to open the Object Browser window.
   
3. Select VBA Project from the top drop-down menu in the window.
   
4. Look to the pane on the right of the window and you should now see your UDF:
   
   If you do not see the UDF in the right pane, click through the items in the left pane until it appears.
5. Right-click your UDF and then click Properties
    
6. In the window that opens, type the description that you want in the Description box and then hit OK.
   
7. Close the Object Browser window, save the file, and go back to Excel. When you type the function and click the fx (insert function) button, you will new see the description of the function that you just entered.
   
   This window also shows any arguments that the function takes.

Notes

It requires a lot of effort to get a UDF to function more like a regular Excel function, but this is one of the easiest things that you can do to give the user more information about what the function does and how to use it.

Make sure to download the sample file attached to this tutorial to work with this example in Excel.