Displaying function and argument descriptions
Adding descriptions to the components of your custom functions is the final finishing touch. It's a nice way of refreshing your memory if you haven't used the function in a while, and it will also be of help to users that are not familiar with your custom functions.
If you use the Insert Function dialog box to insert the PassFail custom function at this stage, no help will be available:
Figure 16.13 – No help on the custom function
In this recipe, we will be adding function and argument descriptions to be displayed in the Insert Functions dialog box.
Getting ready
Make sure that CustomFuntions.xlsm is still open. Activate Sheet1.
How to do it…
What we need to do is the following:
- To add a description to a custom function, open the Macro dialog box: Developer | Code | Macros. The Macro dialog box will appear.
- Click on the Macro name text box and enter the name of...
