Userform that inserts hyperlink for a file location

[lowell.addi]

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.

[Tinbendr]

Welcome to the board!

Try this.

Please Login or Register  to view this content.

[lowell.addi]

Tinbendr:

I inserted your code in place of mine, and I am getting a "Run-time error 438: Object doesn't support this property or method". Any suggestions?

[pareshj]

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