Probably several ways but you can make a lookup table and then use a
worksheet change event keyed by a validation list in cell f7.
Right click sheet tabview codecopy/paste thismodify to suit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$F$7" Then Exit Sub
myvar = Application.VLookup(Target.Value, Range("g7:h10"), 2, 0)
ActiveWorkbook.FollowHyperlink Address:="http://" & myvar
End Sub
--
Don Guillett
SalesAid Software

"ric.todd" wrote in message
ups.com...
Hi All,

Looked EVERYWHERE for this but no luck.

Any idea how to create a data--list dropdown with just simple titles as
hyperlinks so the list would appear like a simple html dropdown with
short titles replacing long hyperlinks? (ie. the same way you create a
list with a column of items on a seperate and refer to that group with
the data validation tool)

Boy if that doesn't sound confusing.

Thanks in advance,

rt