XL98: Second Instance of User Form Moves to Back (200175)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q200175 SYMPTOMS
If you display a message box by clicking a control on a user form that has multiple instances, the latest instance may move behind earlier instances of the user form.
CAUSE
If you use the New keyword to create instances of a user form, and the user form contains a control that has code to display a message box, the message box may cause the latest instance of the user form to move behind all other instances of the user form.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Excel 2001 for Mac.
MORE INFORMATION
The current instance of the user form appears behind all other instances until you dismiss the message box. The current user form then returns to the front position.
This problem does not occur in Microsoft Word 98 Macintosh Edition or Microsoft PowerPoint 98 Macintosh Edition.
REFERENCES
For more information about the New keyword, from the Visual Basic
Editor, 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 Shortcuts to Other Help Files, and then click Visual Basic Language Reference. Click the Index button and type the following text
and then click Show Topics. Select the Dim Statement topic, and
click Go To. If you are unable to find the information you need, ask the
Office Assistant.
For more information about getting help with Visual Basic for Applications, click the article number below to view the article in the Microsoft Knowledge Base:
163435
VBA: Programming Resources for Visual Basic for Applications
| Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
|---|
| Keywords: | kbbug kbnofix KB200175 |
|---|
|