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 vote222 views1 answer
Excel vba automatic calculation
VBA
2 votes214 views1 answer
Excel vba date to string conversion
VBA
1 vote213 views1 answer
Excel vba autofit
VBA
0 vote224 views1 answer
Get current year vb
VBA
0 vote230 views1 answer
How to format a textbox as date vb net
VBA
0 vote222 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote238 views2 answers
Vb.net include quotes in string
VBA
0 vote242 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
1 vote165 views1 answer
Vba Remove Case Sensitivity
VBA