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 vote242 views1 answer
Arq linux
VBA
0 vote196 views1 answer
How to self delete a vbscript file
VBA
0 vote244 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote236 views1 answer
Check range is in another range vba
VBA
1 vote211 views1 answer
How to open cmd with vbd
VBA
0 vote237 views1 answer
Change "location" of binding navigator vb
VBA
0 vote227 views1 answer
Vba dropdown event
VBA
0 vote249 views1 answer
Excel VBA web scraping
VBA
0 vote230 views1 answer
Vb window.minimize
VBA
0 vote251 views1 answer
Vba string
VBA