Custom Function Returns Incorrect Value/Appears to Hang (125723)

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95
Microsoft Excel for Windows 5.0
Microsoft Excel 98 Macintosh Edition

This article was previously published under Q125723

SYMPTOMS

In Microsoft Excel, when you use a custom function, the function may return an incorrectly calculated value, or, during recalculation, the function may appear to hang your computer (to return control to your Microsoft Excel, press the ESC key).

CAUSE

This problem occurs under the following conditions:

The custom function relies on another custom function for at least one of its arguments. -and-
In the declaration line for the custom function, the function arguments have not been declared with data types, as in the following example:
```
      Function Test (arg) As Integer</WWITEM></WWSTEPS>
						
```

WORKAROUND

To ensure that Microsoft Excel calculates the custom function properly, add the expected data types for all arguments when you declare the function. For the example, change the function

   Function Test (arg)

to:

   Function Test (arg As Integer)

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Modification Type:	Minor	Last Reviewed:	10/11/2006
Keywords:	kbprb kbProgramming KB125723