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

0 vote155 views1 answer
Excel vba disable screen update
VBA
3 votes174 views1 answer
Vba http request json
VBA
1 vote176 views1 answer
Excel date to unix timestamp
VBA
0 vote156 views1 answer
Vba len variant
VBA
0 vote162 views1 answer
Excel vba clear filter
VBA
1 vote165 views1 answer
Excel vba first and last row and column in range
VBA
0 vote163 views1 answer
Compare dates vb
VBA
0 vote158 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote166 views1 answer
Nested if else in vb.net
VBA
0 vote159 views2 answers
Get excel file from email attachment in vba
VBA