Hyperlink issue on excel userform

Hi,thanks for your help, but having played around with it, still can't get a way to add it to correct row on worksheet.

My code uses the iRow method to insert data to a fresh line, so not sure how to get the hyperlink to insert into the correct cell with all the other new data on the same row.

Code for the form as it runs without hyperlinks attached: