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 vote222 views2 answers
Vba string to date
VBA
5 votes257 views1 answer
Excel formula how to create strings containing double quotes
VBA
0 vote240 views1 answer
Excel vba hide gridlines
VBA
0 vote232 views1 answer
Vbscript for loop
VBA
1 vote254 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
1 vote245 views1 answer
Excel vba force recalculation
VBA
0 vote225 views1 answer
Vba add month to date
VBA
0 vote237 views1 answer
Switch pictures with buttons vb.net
VBA
18 votes416 views3 answers
Excel-vba make integer
VBA
0 vote236 views1 answer
Vba collection key list
VBA