Userform that inserts hyperlink for a file location

I have created Browse buttons on my userform that open the file dialogue box, and allow me to select a file location. The file name text gets inserted into a corresponding text box. When the userform is submitted, the information goes to a database and is distribtued on the first empty row. The file names get inserted into cells, and I would like for the file names to act as hyperlinks to that specific file location. When I first created this workbook, I could click on the file location, and the file would open, but it is not doing that any longer. I think if the userform can insert the file location as a hyperlink, it will be more user-friendly. Here is the code I have so far:

Please Login or Register  to view this content.

Welcome to the board!

Try this.

Please Login or Register  to view this content.

Hi,

Check the below code and hope this will help you:

Please Login or Register  to view this content.

Where
YourSheetName = Name of the sheet on which you want hyperlink function
And A1 is the cell where Hyperlink function will be placed.
And Filepath = Your file path for eg: "D:\abc.txt"

Regards,
Paresh J