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 vote350 views1 answer
Vba keep command window open
VBA
1 vote349 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
20 votes482 views1 answer
Excel vba factorial
VBA
3 votes331 views1 answer
Vba make long from two shorts
VBA
0 vote323 views1 answer
Vbscript abs
VBA
-1 vote324 views1 answer
For i in range vba
VBA
0 vote382 views1 answer
Excel vba unmerge sheet
VBA
0 vote318 views1 answer
Do until vb.net
VBA
0 vote323 views1 answer
Excel vba open browser
VBA
0 vote334 views1 answer
Type excel.application is not defined vb
VBA