Microsoft KB Archive/192905

= XL98: Dialog Box Show Method Fails with Reference Type Edit Box =

Article ID: 192905

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q192905





SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when you attempt to display a dialog box over another dialog box, and the first dialog box contains a text box that has the Reference or Formula "Edit Validation" type, you may receive the following error message:

Run-time Error '1004':

Show method of Dialogsheet class failed

This error occurs when the second dialog box is displayed during an event macro of a control on the first dialog box, and the first dialog box has not been unloaded.

The error message may be hidden behind your custom dialog box. Press E to dismiss the error and stop the running of your macro.



CAUSE
This is a known limitation with Microsoft Excel 5.0 style dialog boxes. You cannot stack a semi-modeless dialog box (any dialog box that has a Reference or Formula type edit box) on top of another dialog box.



WORKAROUND
To work around this limitation, use either of the following methods.

Method 1: Unload the First Dialog Box Before You Show the Second
Unload the first dialog box before you show the second dialog box (which contains the Reference or Formula type edit box).

Method 2: Use UserForms
Use UserForms instead of Microsoft Excel 5.0 dialogs. UserForms do not have this limitation.

For additional information, please see the following article in the Microsoft Knowledge Base:

111867 XL Err Msg: "Not Enough Stack Space to Run Macro"

Additional query words: XL98

Keywords: kberrmsg kbbug kbnofix kbdtacode KB192905

-

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

© Microsoft Corporation. All rights reserved.