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 vote355 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote370 views1 answer
Enable macros on opening workbook vba
VBA
0 vote355 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote440 views1 answer
Visual basic cmd
VBA
0 vote355 views1 answer
Excel vba address not absolute
VBA
0 vote400 views1 answer
Pivot data source not accepting table named range vba
VBA
31 votes516 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote390 views1 answer
Vba excel parser xml
VBA
0 vote351 views1 answer
Excel vba automatic calculation
VBA
0 vote384 views1 answer
Excel vba disable screen update
VBA