I am making an Excel sheet in which several long lists of items exist. I would like to be able to navigate to those lists by selecting a list's name in a dropdown menu and pressing a button beside it that says "Go!" or something like that.
I have found this tutorial, but it only works for navigation to different sheets:
That would work in personal-use situations, but this Excel document is going to be used as a tool to present internship research findings and should be easy to use for people who might not know this built-in functionality exist. That is why I would like this function to be part of a custom navigation bar like in the picture below.
I've made an example file for your reference. You will need to paste this code into the Sheet1 code module in the attached workbook Please note the Cell references are based on your screenshots. If you change the location of the dropdown this address in the code will need to change accordingly.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$4" Then