XL: Not Possible to Position Custom Dialog Boxes

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

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.