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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
Back
Top