Microsoft KB Archive/184170

= XL98: VBE: User-Defined Functions Are Calculated Incorrectly =

Article ID: 184170

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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.

