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 vote325 views1 answer
Excel vba convert cells address
VBA
0 vote266 views1 answer
Add Formula to Shape Text in VBA
VBA
1 vote306 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote293 views1 answer
Vba check 32 or 64 bit
VBA
0 vote306 views1 answer
Vba array dimensions
VBA
4 votes292 views2 answers
Excel vba last column with data
VBA
0 vote259 views1 answer
Excel vba arrondir
VBA
0 vote311 views1 answer
Iterate all file in a folder vba
VBA
0 vote277 views1 answer
Vbs
VBA
0 vote285 views1 answer
How to get the value of optionbutton in vba
VBA