Not Possible to Position Custom Dialog Boxes

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.