Go to ComboBox

I have the following code that i cannot get to work. In escence i just
want to click on the button and go to the workshhet named in the
combobox. If i take the combobox away and just type a name into a cell
say A4 it works fine. Obviously i am not referencing the Combobox
properly.



Private Sub CommandButton1_Click()
Worksheets(Range("ComboBox1").Value).Activate

End Sub

With thanks

Bob

Your question and supporting code certainly appears to be about Excel. This
newsgroup is for questions and answers about and discussion of Microsoft
Access database software. There are a number of microsoft.public newsgroups
about Excel, where you will almost certainly be able to find a better answer
to your Excel question.

Larry Linson
Microsoft Office Access MVP

"Box666" wrote in message
...
I have the following code that i cannot get to work. In escence i just
want to click on the button and go to the workshhet named in the
combobox. If i take the combobox away and just type a name into a cell
say A4 it works fine. Obviously i am not referencing the Combobox
properly.



Private Sub CommandButton1_Click()
Worksheets(Range("ComboBox1").Value).Activate

End Sub

With thanks

Bob