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

Is my post just that ignorant?

On Nov 16, 9:58 am, "ric.todd" wrote:
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

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

Forgive the stupid question(s) I am a total newbie.

1)So I make my list of hyperlinks as I normally would in the drop-down
sheet?
2)Do I the change the Title there (via right click edit Hyperlink?)
3)Then I am lost...of course I was lost the whole time;)

thx!

rt

On Nov 16, 11:53 am, "Don Guillett" wrote:
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
" wrote in oglegroups.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- Hide quoted text -- Show quoted text -

list a,b,c in data validation cell

vlookup("a",range( ),2,0)
a hyperlink1
b hyperlink2
etc

--
Don Guillett
SalesAid Software

"ric.todd" wrote in message
ups.com...
Forgive the stupid question(s) I am a total newbie.

1)So I make my list of hyperlinks as I normally would in the drop-down
sheet?
2)Do I the change the Title there (via right click edit Hyperlink?)
3)Then I am lost...of course I was lost the whole time;)

thx!

rt

On Nov 16, 11:53 am, "Don Guillett" wrote:
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
" wrote in
oglegroups.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- Hide quoted text -- Show quoted text -