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 vote181 views1 answer
Create links in msgbox in vb
VBA
0 vote202 views1 answer
Vbnet check if string is only letters
VBA
0 vote179 views1 answer
Excel vba unmerge sheet
VBA
0 vote169 views1 answer
Discern between file and folder given path vb.net
VBA
-1 vote179 views2 answers
Excel vba delete empty rows
VBA
0 vote176 views1 answer
Excel vba protect worksheet without password
VBA
0 vote180 views1 answer
Date as number vb
VBA
1 vote186 views1 answer
Find and replace textbox
VBA
0 vote172 views1 answer
.net dark title bar
VBA
0 vote180 views1 answer
Add text to combobox drop down vb
VBA