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

8 votes385 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote338 views2 answers
Checking and changing system volume vb.net
VBA
0 vote322 views1 answer
Vbnet hex to binary
VBA
0 vote312 views1 answer
Vba remove numbers from string
VBA
0 vote334 views1 answer
Vba array dimensions
VBA
0 vote331 views1 answer
Excel vba first working day month
VBA
8 votes433 views1 answer
Vba make a short integer from two bytes
VBA
0 vote335 views4 answers
Jwt token vb.net validation
VBA
5 votes352 views1 answer
Excel vba right word from Long Integer
VBA
0 vote328 views1 answer
Vba compare strings
VBA