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 vote151 views1 answer
Excel vba Column Name to Column Number
VBA
1 vote151 views1 answer
Excel vba get column name from number
VBA
0 vote171 views1 answer
Excel web scraping
VBA
0 vote110 views10 answers
Vba excel create event log
VBA
0 vote164 views1 answer
Vba check if class implements interface
VBA
0 vote144 views1 answer
Excel vba formatconditions positive
VBA
0 vote158 views1 answer
Windows Presentation Foundation dark title bar
VBA
-1 vote176 views1 answer
How save excel through visual basic
VBA
3 votes165 views2 answers
Vba active workbook path
VBA
0 vote139 views1 answer
Vbnet display all axis labels in cahrt
VBA