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 vote129 views1 answer
Windows Forms dark title bar
VBA
0 vote124 views1 answer
Vba collection contains
VBA
8 votes243 views1 answer
Vba make a short integer from two bytes
VBA
0 vote137 views1 answer
Vba paste values
VBA
0 vote99 views1 answer
How to self delete a vbscript file
VBA
1 vote126 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
1 vote124 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote140 views1 answer
VBA Sort RossetaCode
VBA
8 votes142 views1 answer
Excel vba make integer
VBA
0 vote163 views1 answer
Excel vba add reference programmatically
VBA