Page 755 - Excel 2013 All-in-One For Dummies

Creating Custom Excel Functions 737
Figure 2-6:
Entering the Commission user- defined function in the Personal Macro Workbook.
If you want to be able to use your user-defined function in any spreadsheet you create, be sure that you select VBAProject (personal.xlsb) in the Project Explorer window before you open a new module and define the custom function there.
Adding a description to a user-defined function
To help your user understand the purpose of your custom functions, you can add descriptions that appear in Insert Function and Function Arguments dialog boxes that help explain what the function does. To add this kind of description to your user-defined function, you use the Object Browser, a special window in the Visual Basic Editor that enables you to get information about particular objects available to the project that you have open.
To add a description for your user-defined function, follow these steps:
1. Open the Visual Basic Editor from Excel by clicking the Visual Basic button on the Developer tab of the Ribbon or pressing Alt+LV or Alt+F11.
Now, you need to open the Object Browser.
Book VIII Chapter 2
VBA Programming