Combobox to select worksheet?

Hi
I am sure this solution is somewhere on this site but I have searched and cannot find it.
I have a combobox that has a list of 10 items. Each item is represented by a different workssheet. My question is how do i get the combobox to select the correct worksheet each time the respective item is selected in the combobox?

hope this makes sense

Thanks for the reply royUK.
I am using a combobox from the forms menu.

Hello NickFury,

Going with what Roy said about the items being Worksheet names, you can assign this macro to your Forms ComboBox. It will activate the worksheet the user selects.

Please Login or Register  to view this content.

Sincerely,
Leith Ross