Hyperlinks Combo Box

[excelenergy]

My VBA script lists items in my combo box.............What Im trying to do is instead of having the hyperlink listed in the combo box...id like to link a phrase to a website...So for instance instead of having the hyperlink to the CNN website in the combo box...Id just like to have the phrase "CNN Website" and when a user selects that from the drop downbox it takes the user to that website...How would I amend my script to do that? Does anyone know?

Please Login or Register  to view this content.

Thanks!!

[JS411]

Here's one approach. Set up a lookup table like this....
Lookup.jpg

Paste this code into the Sheet Code Module of the Sheet that has the ComboBox.
The code will use the lookup table to populate the ComboBox, and to find the hyperlink address.

Please Login or Register  to view this content.

The Lookup data could be written into the VBA Code if you prefer, but you might find the worksheet table approach shown easier to maintain.