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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Jump to Page according to a number in a cell 3
Need a littel excel help 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Reading a cell based on a vairable 3
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
How to format cell depend on combo choice from another cell 3
Excel How to Autocomplete text/string within a single cell, between different worksheets 1
A macro to check range and then check another range if falset-then 2

Back
Top