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 vote329 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote322 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote315 views1 answer
Excel vba chrw max value
VBA
0 vote320 views1 answer
Send webhook vbscript
VBA
2 votes296 views1 answer
Date format for ms chart vb.net
VBA
0 vote299 views1 answer
Set column width of datagridview vb.net
VBA
0 vote295 views1 answer
Vba get text file content
VBA
0 vote337 views1 answer
Tester si une case est vide vba
VBA
25 votes471 views3 answers
String to date vb
VBA
0 vote297 views1 answer
Vba exit while
VBA