Going to a page depending on a combobox or a number in a cell

[Juke]

Hello everyone,

I've a problem and been searhing for so long and still need help.

I want to use a Combo Box as a shortcut list that will choose a sheet to go.

For example; When I choose "Poems" form the Combo Box list, I want Excel to
open the sheet "Poems".

Alternativley;

If there is a number in cell A1 as "1" than go to (or jump to) "Sheet1",
if the number is "2" than go to "Sheet2" , if the number is "3" than go to
sheet "Poems" etc. etc.

How can I make this?
Really need help..

Kindly regards..

 

[Dave Peterson]

You may want to look at using an addin that would be available for each workbook
you open.

http://contextures.com/xlToolbar01.html
From Debra Dalgleish's site.

 

[Juke]

Kindly regards, thank you very much Dave Peterson.