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 vote344 views1 answer
Loop through all text boxes in a form vb
VBA
0 vote308 views1 answer
Excel vba formatconditions range
VBA
0 vote372 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote347 views1 answer
Excel filter by date not working vba
VBA
0 vote329 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
0 vote323 views1 answer
Vbnet check if number is even or odd
VBA
25 votes494 views3 answers
String to date vb
VBA
1 vote318 views1 answer
Excel vba close form escape key
VBA
0 vote320 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA
0 vote381 views1 answer
Vba userform textbox wrap text
VBA