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 vote276 views1 answer
Vba min
VBA
0 vote266 views1 answer
Convert number to minutes in vba
VBA
0 vote274 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote268 views1 answer
Reset border color textbox vba
VBA
0 vote260 views1 answer
How to extract a file from an ISO:
VBA
0 vote283 views1 answer
Send webhook vbscript
VBA
0 vote314 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote276 views1 answer
Get current year vb
VBA
0 vote268 views1 answer
Sendkeys vba selenium
VBA
0 vote275 views1 answer
Arq linux
VBA