Copy Hyperlink in form to Worksheet

Hi, hope you will all be patient with me.
Redone below

Sorry for the previous mistake in posting, hopefully this is the correct form to post in, as I said I am a beginner at VBA but also at forums - please be patient

Hi, hope you will all be patient with me.
I have been teaching myself how to use VBA / Forms in Excel and so far have created my very first "application".
One problem is all I need to solve - how to transfer on save the hyperlink's I have found / created in the form and have them stay as hyperlinks in the worksheet I send them to.
At the moment I get is the "text" of the link and not the link itself.
The code I am using to place them is
To collect the "link" I use

Please Login or Register  to view this content.

This runs for four cells (Attach1 to Attach4) - each with their own button - everything seems fine in this collection part but when I go to save the form details as below I have problems with the hyperlink part not being there - just the text.

Please Login or Register  to view this content.

heaps of other cells the same - 57 separate past to worksheet fields (didn't include them all here

Please Login or Register  to view this content.

Hope you can help

Leith's hyperlink code tests if the cell contains a hyperlink,so

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

In future please edit the original post,don't just duplicate it leaving the original. This only adds to the post count & sometimes delays answers

Attach the workbook