# Excel question - Dropdown list to hyperlink

**URL:** <https://boards.straightdope.com/t/excel-question-dropdown-list-to-hyperlink/816330>\
**Category:** Factual Questions\
**Created:** [June 18, 2018, 6:25pm UTC](https://boards.straightdope.com/t/excel-question-dropdown-list-to-hyperlink/816330 "2018-06-18T18:25:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![StGermain](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/stgermain/32/2868_2.png) [@StGermain](https://boards.straightdope.com/u/StGermain)\
**Post date:** [June 18, 2018, 6:25pm UTC](https://boards.straightdope.com/t/excel-question-dropdown-list-to-hyperlink/816330/1 "2018-06-18T18:25:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![BubbaDog](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/bubbadog/32/333_2.png) [@BubbaDog](https://boards.straightdope.com/u/BubbaDog)\
**Post date:** [June 18, 2018, 7:05pm UTC](https://boards.straightdope.com/t/excel-question-dropdown-list-to-hyperlink/816330/2 "2018-06-18T19:05:29Z")

</div>

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”

```auto

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](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/drop-down-list-hyperlink/b1fd4b58-43ce-46e4-ad11-a9de86a7fe62)

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.

---

<div class="post-metadata">

**Author:** ![StGermain](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/stgermain/32/2868_2.png) [@StGermain](https://boards.straightdope.com/u/StGermain)\
**Post date:** [June 18, 2018, 7:55pm UTC](https://boards.straightdope.com/t/excel-question-dropdown-list-to-hyperlink/816330/3 "2018-06-18T19:55:21Z")

</div>

**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