Userform startup position xlcenter

BrianExcel · Feb 22, 2011

I want to program my userform to open at xlcenter for both horiz and vert alignments but what I am writing doesnt work.

Code:

load userform1
userform1.show
userform1.horizontalalignment = xlcenter
userform1.verticalalignment = xlcenter

Suggestions?

Datsmart · Feb 22, 2011

This positions my test UserForm in the middle on my screen.

Code:

Private Sub UserForm_Initialize()
    UserForm1.Left = Application.Left + 10
    UserForm1.Top = Application.Top + 30
End Sub

Adjust as needed for your UserForm/Screen.