Home

Cell navigation via dropdown menu

Deleted
Not applicable

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 beside it that says "Go!" or something like that.

 

I have found this tutorial, but it only works for navigation to different sheets:

http://contexturesblog.com/archives/2016/03/17/excel-sheet-selector-with-no-macros/

 

Would anyone have any ideas on how to make this work? :) 
It might just be a small change to that tutorial, but I wouldn't know what.

 

Thank you!

4 Replies
Highlighted

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.

 

NamedRange.png 

Highlighted

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.

 

Capture.PNG

 

Highlighted

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

Highlighted

Tim-

 

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

Related Conversations
Menu not displaying thumbnails
Jez_Fernandez in Sway on
0 Replies
Excel ComboBox (ActiveX Controls) dropdown not functioning
Kpizzle in Excel on
1 Replies
Feature Request: Add Delete option to Downloads
Eric Hebert in Discussions on
4 Replies
Megamenu switches back to cascading on a hub site
Beat Grüring in SharePoint on
11 Replies