List of files in selected folder and subfolders

I am using the following code, developed by other/s in this forum, to list all the files in a selected folder and its sub-folders.
It works.
However the user can only select the folder within VBA editor.
Is there a way to incorporate a user dialogue to choose the folder (such as "msoFileDialogFolderPicker").

Please Login or Register  to view this content.

This won't work.
I get an error message "Compile error: Argument not optional".

Yes, i forgot there are to parameters.

Please Login or Register  to view this content.

Thank you again.