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 vote157 views1 answer
Vba loop through files in folder
VBA
1 vote151 views1 answer
Find and replace textbox
VBA
2 votes146 views1 answer
Excel vba date to string conversion
VBA
0 vote147 views1 answer
Move bindingnavigator vb
VBA
0 vote156 views1 answer
If statement vdhl
VBA
0 vote146 views1 answer
Change form background image vb
VBA
0 vote156 views4 answers
Vgrive,deb
VBA
0 vote144 views1 answer
Vba boolean to string
VBA
0 vote152 views1 answer
Excel vba DisplayAlerts
VBA
0 vote129 views1 answer
Remove frist letter from string vbnet
VBA