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 vote156 views1 answer
Vba set vs dim
VBA
0 vote204 views1 answer
Vba text to general
VBA
0 vote207 views1 answer
Change "location" of binding navigator vb
VBA
0 vote195 views1 answer
Docker vboxmanage not found
VBA
0 vote217 views1 answer
Enable macros on opening workbook vba
VBA
1 vote209 views1 answer
Vba reverse string
VBA
18 votes276 views2 answers
Vba make word from bytes
VBA
0 vote205 views2 answers
Delete all controls from list of control vb.net
VBA
1 vote211 views1 answer
Add a index column power bi
VBA
0 vote217 views1 answer
Excel vba select multiple shapes
VBA