Microsoft KB Archive/134611

= MS Excel Hangs When You Set Options for Custom Function =

Article ID: 134611

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0c

-



This article was previously published under Q134611



SYMPTOMS
In Microsoft Excel, you will receive an Invalid Page Fault error or a general protection (GP) fault if you attempt to set options for a user- defined function that accepts variables of a user-defined type.



CAUSE
This error will only occur if both of the following conditions are true:   The user-defined function accepts variables of a specified type. For example, the following function accepts a "NewType" type variable: Function Test(X As NewType) Test = "Hello" End Function NOTE: The problem will not occur if the function accepts variables of any type or if it does not accept variables at all.

-and-   The type of the variable being accepted by the function is a user- defined type. Any type NOT included in the following list is a user- defined type:      Boolean   Integer Long     Single Double   Currency Date     Object String   Variant 

If both of these conditions are true, attempting to set options for the function through the Object Browser dialog box may result in an Invalid Page Fault or a GP fault.



WORKAROUND
To prevent this error from occurring, remove all variables from the user- defined function and then set the options for the function. Once the options have been set for the user-defined function, you can then add the variables back into the function.

For example, if your user-defined function reads as follows Function Test(X As Integer, Y As NewType) Test = X * Y  End Function remove the variables from the function declaration line, so that it resembles the following example: Function Test Then, set the options for the function by following these steps:
 * 1) On the View menu, click Object Browser.
 * 2) In the Methods/Properties list, click the name of the function.
 * 3) click Options.

Once the options are set, add the variables back into the function: Function Test(X As Integer, Y As NewType)



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 5.00c vba.dll vba32.dll udf XL

Keywords: kbdtacode KB134611

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.