Links within combo box

  • Thread starter Thread starter SM
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Logic within combo boxes? 2
Unprotect Combo Box in a Protected Sheet 3
Graph linked with combo boxes 2
Linking a combo box 1
combo box 2
Combo Box 1
Combo Box and Sorting 3
Excel 2007 Combo Box questions 1

Back
Top