Here one Solution, you may want to try. Paste the following code into
the worksheet that contains your validation list. Replace the column
number. I took 10 in my solution.
After that when you validate the cell and go to another cell,
it will become an hyperlink as I do not think it is possible to have
the link still active in a validation.

Let me know what you think.
Francoise;)


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'In sample 10 is the column Number, replace with the number position of
your validation hyperlink
If Target.Column = 10 Then
'If one cell selected then transform the address in hyperlink
If Target.Cells.Count = 1 Then
Hyperlinks.Add Target, Target.Text
End If
End If
End Sub


--
sunnyland
------------------------------------------------------------------------
sunnyland's Profile: http://www.excelforum.com/member.php...o&userid=30871
View this thread: http://www.excelforum.com/showthread...hreadid=505580