XL97: VBE: User-Defined Functions Are Calculated Incorrectly (170650)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q170650

SYMPTOMS

When you use the Function Wizard to enter a formula containing 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 97 for Windows 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 that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:5/8/2002
Keywords:kbprb kbProgramming KB170650
©2002 Microsoft Corporation. All rights reserved.