XL98: VBE: User-Defined Functions Are Calculated Incorrectly (184170)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q184170 SYMPTOMS
When you use the Function Wizard to enter a formula that contains a user-
defined function in a cell, the formula may be calculated more than once.
CAUSE
A user-defined function is calculated multiple times in Microsoft Excel 98
if the following conditions are true:
- The user-defined function is created in Visual Basic for Applications.
-and-
- The user-defined function is inserted into the spreadsheet with
the Function Wizard.
Note that this behavior does not occur if the user-defined function is
entered directly in a cell in a worksheet.
WORKAROUND
To work around this problem, do not use the Function Wizard to insert the
custom function.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
REFERENCES
For more information about entering formulas, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
Microsoft Excel Help, type the following text
and then click Show Topics. Select the "About using functions to calculate
values" topic, and click Go To. If you are unable to find the information
you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbbug KB184170 |
|---|
|