Excel vba center userform

' On application window
Private Sub UserForm_Initialize() 
   Me.Top = Application.Top + (Application.UsableHeight / 2) - (Me.Height / 2) 
   Me.Left = Application.Left + (Application.UsableWidth / 2) - (Me.Width / 2) 
End Sub 
' Or
With myForm
    .StartUpPosition = 0	' Manual
    .StartUpPosition = 1	' CenterOwner	
    .StartUpPosition = 2	' CenterScreen
    .StartUpPosition = 3	' WindowsDefault, screen top left
End With

Source: bettersolutions.com

Similar codes

1 vote100 views1 answer
Ms access open form to new record
VBA
0 vote161 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote145 views2 answers
Excel vba prevent save
VBA
1 vote186 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
1 vote157 views1 answer
How to put a gridpain in a vbox
VBA
0 vote116 views1 answer
Vba set vs dim
VBA
3 votes156 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote156 views1 answer
Vbs
VBA
0 vote194 views1 answer
Vba userform textbox wrap text
VBA
0 vote157 views1 answer
Send text to clipboard vb.net
VBA