Article ID: 200175
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 98 for Macintosh
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.
STATUS
Microsoft 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
Additional query words: XL98 vba XL excel VB Visual Basic Message box user form deselected select highlight button dialog
Keywords: kbbug kbnofix KB200175