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 vote189 views1 answer
Excel vba protect content
VBA
0 vote137 views1 answer
Vba change named range address
VBA
0 vote136 views1 answer
Vba get relative cell address
VBA
0 vote131 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote186 views1 answer
Visual basic cmd
VBA
1 vote147 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
5 votes154 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote144 views1 answer
Vbs expand env var
VBA
2 votes129 views1 answer
Vba uppercase first letter of each word
VBA
0 vote92 views1 answer
How to make a if statement with vbs
VBA