Create a drop down menu when selected will take me to a different sheet?

Maybe...

Please Login or Register  to view this content.

No worries...

With the code I posted, it is Sheet module code...

Paste code in a Sheet module

• Where to paste code
• Highlight macro to copy >> Ctrl + C >> Open your workbook
• Right click on sheet tab >> View Code >> Opens the Visual Basic Editor (VBE)
• Ctrl + R >> opens the Project Explorer (if not already open on left side of screen)
• Paste code >> Ctrl + V (right side of screen)
• Alt + Q >> exits VBE and returns to Excel
• Now simply make a change in target cell

The target cell is A1. A1 contains the drop down menu from a list (24 names).

When you change the sheet name in A1 the code will fire activating the sheet name you selected.

Originally Posted by SamTB

I'm getting no where! Can't seem to get it to work? The list is part of a merged cell? Is this an issue??

It's probably a good idea to give a more descriptive picture up front of what we are working with.

Anyway, I think at this point you might want to craft a small representative sample of what you have and what you want so we can ensure it is working as you wish.