Links within combo box

S

SM

Hello,

I would like add a combo box to my worksheet, and have the
options displayed in the list link to certain pages on our
external company website. I have attempted to do this,
with no success. Any help would be greatly appreciated.
 
K

Karl

try this

Private Sub ComboBox1_Change()
ActiveWorkbook.FollowHyperlink Address:=ComboBox1.Text, NewWindow:=True
End Sub

I did the list of the links off screen (hidden) filled the list via the
properties (listfillrange) and it seems to work

Never tried before but there was no replies so I thought I would give it a
go
 
Top