The Functions in the Function Wizard
In Microsoft Excel 5.0 and Microsoft Excel 95, you could assign custom functions by using a category’s object catalog in the Function Wizard. After Excel 97, this was no longer possible because the object catalog changed. Functions created with VBA are still assigned by using the Function Wizard.
Using Your Own Functions
All properly defined functions can be used in a worksheet. If cell A1 contains a positive number for the radius, you can calculate the area of the circle with the formula =AreaCircle(A1) in cell B1. For this to work, the module and the worksheet must exist in the same workbook, otherwise you will get the #NAME? error.
A custom function can also be used in another workbook. With the workbook open, ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
