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 vote238 views1 answer
Vba extract filename from path
VBA
1 vote233 views1 answer
Vba loop through files in folder
VBA
0 vote199 views1 answer
Excel vba milliseconds
VBA
0 vote201 views1 answer
Vb window.minimize
VBA
3 votes242 views2 answers
Vba date to string
VBA
4 votes216 views1 answer
Excel vba how to reset usedrange
VBA
0 vote215 views1 answer
Excel vba extract year
VBA
3 votes253 views1 answer
Excel vba make long from two shorts
VBA
0 vote202 views1 answer
Check range is in another range vba
VBA
1 vote208 views1 answer
What does vbs stand for
VBA