Populate a userform textbox with filename

[Belleke]

Hello dear helpers,
I want to populate a textbox with filename
Something like this

Dim sFileName As String
sFileName = Application.GetOpenFilename("MS Excel (*.xlsx), *.xls")
TBfilename.Text = sFileName

but instead of an excel file it should be a pdf file
please advice

 

[Marc L]

Hi !

Just replace Excel parameter by the one for pdf like in Windows Explorer.

The question is : what's the purpose as Excel can't open a pdf file ?
​