如何通过excel中的vba表单链接文件

I created a form that allows the user to click a button and then it allows you to browse and find your document or whatever and will submit it as a link with other related data. I'm wondering if their is a way to allow the user to make the link connect to a folder filled with multiple files without having them do it manually. Here is my code belowI created a form that allows the user to click