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 vote226 views1 answer
Create links in msgbox in vb
VBA
0 vote217 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote220 views1 answer
Vba declare 64-bit ptrsafe
VBA
13 votes500 views2 answers
Vba write text file
VBA
0 vote235 views1 answer
Vba variable number of arguments
VBA
0 vote211 views1 answer
Vbnet add new ecel sheet
VBA
1 vote211 views2 answers
Get all column names from excel vba
VBA
1 vote228 views1 answer
Vbscript convert ascii code to character
VBA
1 vote246 views1 answer
Vba loop through files in folder
VBA
0 vote234 views1 answer
Excel last used row
VBA