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

5 votes119 views1 answer
Excel vba how to unit test vba code
VBA
1 vote130 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
4 votes119 views1 answer
Excel vba check cell not empty
VBA
0 vote119 views1 answer
Compare dates vb
VBA
0 vote157 views1 answer
Vba array of integers
VBA
0 vote73 views1 answer
How to sort datagridview in vb.net
VBA
0 vote112 views1 answer
Excel vba milliseconds
VBA
0 vote136 views2 answers
Vb.net include quotes in string
VBA
0 vote140 views1 answer
Wpf dark title bar
VBA
0 vote119 views1 answer
Vb test if reference is null
VBA