Navigate Via Data Validation Drop Down List

[VinceF]

Cross-posted at https://www.mrexcel.com/board/thread...-list.1201363/

Hello Experts,

Your assistance would be very much appreciated.
With extremely limited VBA skills what I'm hoping that can be accomplished is...

I have a total of11 sheets in the workbook with a Data Validation Drop Down list in cell B2 of Sheet 1 which is named, "Main". The DD list contains the names of the remaining 10 sheets and my hope is to be able to navigate to those sheets by selecting them via the drop down list.


Thanks in advance for your assistance.
VinceF
Excel 2016
Win10

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added the link because you do not have enough posts.

[6StringJazzer]

Put this code into the module for sheet Main:

Please Login or Register  to view this content.