Including Hyperlink in a lookup?

[mageeg]

Hi,

I have a form where the user enters a Serial number and pulls through the row of information from the database in which that serial number is stored.

the following piece of code does this:

'code for receiver range, *if number entered is between range then lookup rest of data*


    ID = SerialNumber.Value
    
        For Each i In Sheets("ReceiverData").Range("Table2[From]")
        
        StartID = i.Value
        EndID = i.Offset(0, 1).Value
        
            If ID >= StartID And ID < EndID Then

            txtType.Value = i.Offset(0, 3).Value
            txtSize.Value = i.Offset(0, 4).Value
            txtWKPRESS.Value = i.Offset(0, 6).Value
            txtCertDate.Value = i.Offset(0, 5).Value
            TextBox22.Value = i.Offset(0, 7).Value
            
            End If
        
        Next i

End If

However TextBox22 (the last line) is a hyperlink. Is there anyway to do this whilst including the hyperlink?