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 vote306 views1 answer
Vba keep command window open
VBA
0 vote295 views1 answer
Add text to combobox drop down vb
VBA
0 vote280 views1 answer
Vbs expand env var
VBA
0 vote290 views1 answer
Weekday vba
VBA
1 vote273 views1 answer
Textbox find and replace vb
VBA
0 vote288 views1 answer
VB get external IP address
VBA
0 vote286 views1 answer
String contins in vba
VBA
1 vote268 views1 answer
How to do error handling in access vba
VBA
0 vote286 views1 answer
Not allow form to be resized
VBA
8 votes350 views1 answer
Excel vba determine number of elements in a 2D array
VBA