Select Sheet based on Combo box selection

I am trying to set up a (simple?) routine that asks a user to select their name from a combo box then go to a sheet based on their selection. So the name they select in the combo box goes into cell c11 and I use a vlookup formula "=VLOOKUP(C11,PEOPLEDATA,5)" on the range of alphabetically listed names to give me the name of the sheet I want to goto in cell d11. Then I'm stuck for the code that will take me to the page identified in cell d11.

Can it be done directly from the combo box selection?

Ultimately this will be in a protected / shared workbook (2010)

You cannot change sheet with any formula I am aware of.
You can easily do it with VBA triggered at the Combobox.change event.

hi Dave, if sheet name is in D11:

Please Login or Register  to view this content.

Thank you, I will try that out. My solution ran to over 90 lines!

please check attachment, press Go button, change value in D11

if you post sample file we could work something out for you

Hi waterserv, your first solution works just once, on subsequent selections I get an error. The attached file "Dave.xlsm" isn't a user selection combobox. This is a sample of the code I'm using

Please Login or Register  to view this content.

Originally Posted by Dave Herbert

Then I'm stuck for the code that will take me to the page identified in cell d11.

The file posted was an answer to your remark in post #1. The file works as expected within the set conditions.
As for the example with the combobox the sample file is attached

Thank you watersev, that looks brilliant!

Thanks watersev for your help, I have been too busy to log in.