XL98: VBE: User-Defined Functions Are Calculated Incorrectly

ID: Q184170

The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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

entering data, formulas
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.

Additional query words: XL98

Keywords : kbdta xlvbainfo OffVBA
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: January 19, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.