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.

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

hi Dave, if sheet name is in D11:

Sheets(CStr(Range("d11"))).Activate

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

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

Private Sub ComboBox1_Change()
Select Case ComboBox1.Text
Case "Abbott, John"
Worksheets("jabbot").Select
Case "Baah, Michael"
Worksheets("mbaahx").Select
Case "Baron, Mike"
Worksheets("mbaron").Select
Case "Bartmanis, Nicolas"
Worksheets("nbartm").Select
Case "Bell, Michelle"
Worksheets("mbellx").Select
Case "Blackburn, Lyn"
Worksheets("lblack").Select
Case "Bloodworth, Robin"
Worksheets("rblood").Select
....
Case Else
End Select
End Sub<

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.