Combobox to choose Worksheet
 

I have a workbook with a combobox and around 30 sheets,
I need to select sheet dependent on value in combobox,
the following code doesnt quite help- an help much appreciated- thks

Private Sub ComboBox1_Click()

Worksheets.Select = ComboBox1.Value

End Sub

Combobox to choose Worksheet
 

"teresa" wrote in message
...
I have a workbook with a combobox and around 30 sheets,
I need to select sheet dependent on value in combobox,
the following code doesnt quite help- an help much appreciated- thks

Private Sub ComboBox1_Click()

Worksheets.Select = ComboBox1.Value

End Sub

Hi Teresa,

Assuming the value in the combo box is exactly the same as one of your
sheet tab names, this should do the trick.

Worksheets(ComboBox1.Value).Activate

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm