Add a hyperlink from text box

Hi Guys,

Kindly need your advice to add a hyperlink to a data in excel which inputted from a text box using macro. When a link typed in path text box in the user form, the link will automatically added to the data.
This is really necessary for my daily work, it can save quite some time if I want to review a case, as I just need to click the link from the excel report instead of open the specific folder from my computer directory. Herewith I attach an excel I have create as the sample for more details.

Originally Posted by skywriter

I'm understanding that what you want is to enter a file number in the form and that number will be the text in a cell that is an actual hyperlink to the file you specify in file path box.

This code assumes you type the full path name, which would include the name of the file.

Good Luck!!!

Dear Skywriter,

Thank you very much!! This is exactly what I want