Private Sub UserForm_Initialize()
Dim Cell As Range
Dim H As Hyperlink
Dim i As Byte
With Sheets('Sheet1')
For Each H In .Hyperlinks
For Each Cell In .Range('A1:A10')
If H.Range.Address = Cell.Address Then
i = i + 1
With Me.Controls('Label' & i)
.Caption = H.Parent
.Tag = H.Address
End With
End If
Next Cell
Next H
End With
End Sub