Microsoft KB Archive/180353

= XL98: Visual Basic Editor Appears When You Display UserForm =

Article ID: 180353

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q180353



SYMPTOMS
If you run a Microsoft Visual Basic for Applications macro that displays a UserForm, the Visual Basic Editor may appear when the UserForm is displayed.



CAUSE
This problem may occur when the following conditions are true:


 * In the Visual Basic Editor, the UserForm window is the active window. -and-


 * You do not switch back to Microsoft Excel by clicking "Close and Return to Microsoft Excel" on the File menu. Instead, you click a workbook window in the background. -and-


 * You then run a macro that displays the UserForm.

Note that when you close the UserForm, the Visual Basic Editor disappears from the screen.



WORKAROUND
To prevent this problem from occurring, do either of the following:


 * Switch back to Microsoft Excel by clicking "Close and Return to Microsoft Excel" on the File menu. -or-


 * Before you switch back to Microsoft Excel, activate a window other than a UserForm window (for example, a module window or the project window).



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: XL98 vbe custom dialog box

Keywords: kbbug KB180353

-

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

© Microsoft Corporation. All rights reserved.