Excel question - Dropdown list to hyperlink

Factual Questions
1

I want to create a dropdown list (I can do that) in which the source list contains hyperlinks to other sheets within the workbook. My source has the hyperlinks, I can do the dropdown, but it doesn’t take me to the sheet referenced in the source list.

Any ideas?

StG

2

You can do this with a ComboBox and a small Macro. If you’re unfamiliar with Macros the link I have at the bottom of this could possibly guide you through it.

First -
Name your range listing the hyperlinks as “Hyperlinks”
Name the range for the result link of Combo Box “Linked_Cell”



Sub DropDown8_Change()
HyperLink_Index = Range("Linked_cell")
      If Range("HyperLinks").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Name <> "" Then
           Range("HyperLinks").Offset(HyperLink_Index - 1, 0).Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
    End If
End Sub

Assign the above macro to your combo box

Helpful Explanation

I had never done a hyperlink choice like this but found this to be pretty straightforward. If you are unfamiliar with coding please know that the range names I stated above must be entered as shown.

3

BubbaDog - I’ve done macros, many of them. Assigned to shortcut keys or run manually. But never assigned to a combo box. I’ll have to play with this. Thanks!

StG