Microsoft Office Tutorials and References
In Depth Information
Using Add-ins to Store Custom Functions
Figure 10-12: Provide a function description in the Macro Options dialog box.
7.
Click OK and then click Cancel.
After you perform the preceding steps, the Insert Function dialog box displays the description
that you entered in Step 6 when the function is selected.
When you use the Insert Function dialog box to enter a function, the Function Arguments dialog
box is displayed after you click OK. For built-in functions, the Function Arguments dialog box
displays a description for each of the function’s arguments. Unfortunately, you can’t provide such
descriptions for custom function arguments.
Using Add-ins to Store Custom Functions
You may prefer to store frequently used custom functions in an add-in file. A primary advantage
is that you can use those functions in any workbook.
In addition, you can use the functions in formulas without a filename qualifier. Assume that you
have a custom function named ZapSpaces , and that it’s stored in Myfuncs.xlsm . To use this
function in a formula in a workbook other than Myfuncs.xlsm , you need to enter the following
formula:
=Myfuncs.xlsm!ZapSpaces(A1:C12)
If you create an add-in from Myfuncs.xlsm and the add-in is loaded, you can omit the file
reference and enter a formula such as the following:
=ZapSpaces(A1:C12)
I discuss add-ins in Chapter 21.
 
Search JabSto ::




Custom Search