Microsoft KB Archive/109423

= Not Possible to Position Custom Dialog Boxes =

Article ID: 109423

Article Last Modified on 8/15/2003

-

APPLIES TO


 * Microsoft Excel 95a
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q109423



SUMMARY
In the versions of Microsoft Excel listed at the beginning of this article, it is not possible to directly affect the on-screen position of a custom dialog box when it is displayed.

NOTE: A note at the top of page 225 in the Visual Basic "User's Guide," version 5.0, states that you can cause a custom dialog box to appear at a specific location. This information is incorrect.



MORE INFORMATION
The DialogFrame.Left and DialogFrame.Top properties can be used to change the position within a dialog sheet of a dialog frame. However, changing these properties does not affect the on-screen position of a custom dialog box when you show it by using the DialogSheets("Dialog1").Show method.

In Microsoft Excel, when a dialog box is shown, its upper-left corner will be located in the same position as the upper-left corner of the last dialog box shown.

Other dialog boxes, such as the Open and Save As dialog boxes, follow the same rule. For example, when the Open dialog box is visible and you choose the OK button to remove it, the next dialog box that appears on the screen will appear with its upper-left corner in this same position.

NOTE: If, when you display a dialog box, part or all of the dialog box is pushed off the edge of the screen, Microsoft Excel automatically shifts the dialog box so that the whole dialog box is visible.

Additional query words: XL5 XL7 XL

Keywords: KB109423

-

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

© Microsoft Corporation. All rights reserved.