In design mode double click the command button and paste the below 1 line code

Private Sub CommandButton1_Click()
Sheets(ComboBox1.Value).Activate
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"Bob" wrote:

I am trying to create a simple index page as the first sheet in
workbook.

The book has over 20 worksheets in it. On sheet1 I would like to have
a dropdown (ComboBox) for people to select the worksheet that they
want to go to and then a control button for them to click which will
then take them to the selected worksheet.

Each worksheet is known as €œsales€� ,€œstock€� etc it is these names I
have put into the ComboBox, each worksheet has its known name quoted
in cell A4 ie €œSales€� is sheet7 and in cell A4 of sheet7 there is the
word €œSales€�. The same applies for all worksheets..

Is the above the best way to go with this where the name in the
ComboBox matches a known cell on each worksheet and by clicking on the
command button you go straight to that worksheet. (if so how) or is
there a better way to select and then go to a chosen worksheet.

With thanks

RJG