XL2000: How to Display a Custom Function in Step 2 of the Function Wizard (213183)
The information in this article applies to:
This article was previously published under Q213183 SUMMARY
In Microsoft Excel 2000, you can create a custom Microsoft Visual Basic for Applications function to perform calculations. By default, this custom function appears in the Function Wizard under the function category called "User Defined." You can call custom functions with the Function Wizard in Excel just as you call built-in functions.
However, there may be times when you want to use a Visual Basic for
Applications macro to bypass step 1 of the Function Wizard and display a
particular custom function in step 2 of the wizard. This article
demonstrates how to automatically display step 2 of the Function Wizard with a macro and populate it with your custom function.
REFERENCESFor more information about user-defined functions, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type function statement in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbhowto KB213183 |
---|
|