Forum Discussion

Anonymous's avatar
Anonymous
May 16, 2018

Cell navigation via dropdown menu

Hello! 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...
Formulas & Functions
Need Help
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 17, 2018

You can use the range drop down in the top left corner by the function box.  This functionality is already built into the software.  There is no need to make buttons unless I'm missing something simple.

 

 

  • Anonymous's avatar
    Anonymous
    May 17, 2018

    Thank you for your message!

     

    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.

     

     

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      Jun 08, 2018

      Tim-

       

      Just wanted to follow up and see if you were able to resolve your issue.

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      May 17, 2018

      Tim-

       

      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
    Range(Target.Value).Select
End If

End Sub

Resources