Opening a sheet through a combo box

[Darrenh1238]

Hi all,

I have a spreadsheet that has multiple tabs named "Product A", "Product B", "Product C" etc.

On a seperate sheet, I would like to have a combo box where I can select one of the above products from the drop-down list and then have that specific tab open.

I have created the combo box button and specified the "input range" which is the list of sheet names. I'm struggling to create a macro that will open up the relevant sheet name once selected from the combo box.

I've searched the forums for a solution, but can't find anything that will work, so hoping for a step by step solution to my query if possible. I've found the below, but it does not work, I get a debug error message stating "invalid use of me keyword".

Please Login or Register  to view this content.

Thank you.

[davesexcel]

Please Login or Register  to view this content.

[Darrenh1238]

EDIT - Thanks Dave.

Solved it now