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 vote176 views1 answer
Random number generator vb.net
VBA
0 vote179 views1 answer
Vbnet check if sting contians symbols
VBA
2 votes180 views1 answer
Vba file from path
VBA
0 vote175 views1 answer
Vba run command
VBA
0 vote191 views1 answer
Vba line feed
VBA
0 vote185 views1 answer
Vbs expand env var
VBA
1 vote171 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote200 views1 answer
Vba is integer
VBA
1 vote182 views1 answer
Export datagridview to excel vb.net
VBA
8 votes207 views1 answer
Excel vba make a short integer from two bytes
VBA