Clickable email validation drop downd List

[nesman10]

Im trying to email directly from my worksheet by scrolling through a drop down list of emails that is in a validation List I set up.
I would like to choose the correct email and then click on the cell again whereon it opens a new Outlook email window to the selected email address.
I dont want to let the email stick, want the hyperlink to reset to general so that I can select another email next time and repeat the same.
I can paste vba code if needed.
Please Help.
Thanks Nesman10

 

[HippoCampus]

Evening

Andy Pope from the Ozgrid group suggest that

Private Sub Worksheet_Change(ByVal Target As Range)

' change D5 to appropriate cell
If Not Intersect(Target, Range("D5")) Is Nothing Then
MsgBox "Hyperlink to " & Target.Value
''' ThisWorkbook.FollowHyperlink Target.Value
End If

End Sub

Added to the event code to the worksheet

( http://www.ozgrid.com/forum/showthread.php?t=64697 )

HTH