Forum Discussion
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 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
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.
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.
Tim-
Just wanted to follow up and see if you were able to resolve your issue.
