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
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
6 votes223 views1 answer
Excel vba isalpha
VBA
3 votes206 views1 answer
Excel vba change format of cell
VBA
0 vote197 views1 answer
Vb net check if file exists
VBA
0 vote198 views1 answer
Enter into cells data grid view
VBA
0 vote205 views1 answer
Search in richtextbox vb.net
VBA
0 vote212 views1 answer
Dlete rows with blanks and space " " vba
VBA
0 vote198 views1 answer
Vba parameter adodb null value
VBA
18 votes533 views2 answers
Vba make word from bytes
VBA
0 vote212 views1 answer
Excel vba Column Name to Column Number
VBA