Compile error help and centering Title on userform

[Pookiemeister]

The below code gives me a compiling error. "Compile error: Wrong number of arguments or invalid property assignment" The error seems to occur on the .Filters.Add
The .Add is highlighted in blue if that helps.

How can I center the title text on a userform.

Private Sub cmdBrowse_Click()    
    'myFile = Application.GetOpenFilename(, , "Select a File.")
    
    Dim fname As String
    Dim fpath As String
    
    fpath = ThisWorkbook.Path
    
    With Application.FileDialog(msoFileDialogOpen)
        .InitialFileName = fpath
        .ButtonName = "Get File Name"
        .Title = "File Selection"
        .Filters.Clear
        .Filters.Add "*.xl", "*.xlsx", "*.xlsm", "*.xlb", "*.xlam", "*.xltx", "*.xltm", "*.xls", "*.xla", "*.xlt", "*.xlm", "*.xlw"
        .AllowMultiSelect = False
        
        If .Show = True Then
            fname = .SelectedItems(1)
            Me.TextBox1.Text = fname
        Else
            MsgBox "Operation Canceled"
        End If
    End With
End Sub

Thank You

 

[shknbk2]

The number of arguments was wrong. Pressing F1 while the cursor is on the word Filters takes you to a help page with an example of Filters.Add.

.Filters.Add "Excel files", "*.xl;*.xlsx;*.xlsm;*.xlb;*.xlam;*.xltx;*.xltm;*.xls;*.xla;*.xlt;*.xlm;*.xlw"

I don't know how you can format the title to be centered on a built-in dialog box. Probably can't be done. Though a work around would be to add a bunch of spaces in front of the text to move it to the right.

 

[Pookiemeister]

Thank you. That worked. I see where I went wrong. I forgot to ask, but to open the file, I would have to create an open button and put

fname.open

to open the file. Is that correct? Thank you for your help.

 

[shknbk2]

The code to open the workbook is

Workbooks.Open fname