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 vote225 views1 answer
Excel vba automatic calculation
VBA
0 vote236 views1 answer
Excel vba convert cells address
VBA
0 vote280 views1 answer
Vba dictionary clear
VBA
0 vote224 views1 answer
Vba string start with
VBA
0 vote218 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote214 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote250 views1 answer
How to enter Vbox manage commands
VBA
3 votes218 views1 answer
Excel vba last row in range
VBA
0 vote239 views1 answer
Vba search string position
VBA
5 votes239 views1 answer
Vba low byte from INTEGER
VBA