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

-1 vote286 views1 answer
Vba sendkeys
VBA
0 vote230 views1 answer
Vba text to general
VBA
1 vote235 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
0 vote238 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote230 views1 answer
Vba variable number of arguments
VBA
0 vote235 views1 answer
Excel vba move down to next visible cell
VBA
0 vote237 views2 answers
Open url from vba
VBA
0 vote281 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote237 views1 answer
VBA is form loaded
VBA
0 vote226 views1 answer
Putting marquee in vb.net
VBA