You should make a list of all of the worksheet names and then define th
list as a named list (Insert Name Define).
Now in the Rowsource property of the combobox insert
sheet!name
where sheet is the worksheet containing your named list and name is th
defined name of the list.
When you run the combobox now then you will have the worksheets t
select from.
Finally place the following code
Code
-------------------
Private Sub ComboBox1_Change()
Worksheets(ComboBox1.Text).Activate
End Sub
-------------------
changing combobox1 to match the name of your combobox.
HTH
Gordo
--
Message posted from
http://www.ExcelForum.com