Add Hyperlink to cell via a userform

Hello,

I would like to add a hyperlink to a cell via a userform instead of using the "Hyperlink" button from the right click menu.

The structure of the userform should be identical to the attached screen.

The browse button should open up a browser window for users to browse for the file. The address of the link will be displayed in the text box.

Then when "OK" is clicked, the hyperlink should be attached to the selected cell.

Your help is much appreciated.

best regards,
tapapad