Display a dialog box (eg Data Validation) like this
Sub Dialog()
Application.Dialogs(xlDialogDataValidation).Show
End Sub
Userforms can be used to create customised dialog boxes whose screen positions can be specified by the creator.

Is there any way to control the screen position of Excel built-in dialogs?
Thank you