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 vote356 views1 answer
Show unix time in vba
VBA
0 vote349 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote341 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote353 views1 answer
Not allow form to be resized
VBA
0 vote339 views1 answer
Vba first line of string
VBA
0 vote349 views1 answer
Remove frist letter from string vbnet
VBA
1 vote404 views1 answer
Excel vba get column number from column name
VBA
1 vote330 views2 answers
Excel vba password protect
VBA
-1 vote338 views2 answers
How close excel through visual basic
VBA
0 vote360 views2 answers
How to concatenate more than 40 lines in vba
VBA