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 vote203 views1 answer
Vba character ascii code
VBA
0 vote190 views1 answer
Vbscript check if string is empty
VBA
0 vote196 views1 answer
Vbnet line chart showing extra space
VBA
0 vote199 views1 answer
Excel vba formatconditions positive
VBA
0 vote219 views1 answer
How to call gcd in vba
VBA
0 vote196 views1 answer
Vba range clear formatting
VBA
5 votes201 views1 answer
Excel-vba get integer high byte
VBA
0 vote185 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote189 views1 answer
Refresh token em vb net
VBA
3 votes187 views1 answer
Vba make long from two shorts
VBA