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
VB Error Code BC30201
VBA
0 vote269 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote254 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote201 views1 answer
Excel vba DisplayAlerts
VBA
0 vote216 views1 answer
Vba foreach 2d array
VBA
0 vote173 views1 answer
Enable macros on opening workbook vba
VBA
-1 vote170 views1 answer
For i in range vba
VBA
0 vote179 views1 answer
Excel vba calculate
VBA
0 vote190 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote163 views1 answer
Vba word pdf table to excel
VBA