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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Juke - 24 Nov 2006 11:25 GMT

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

Reply to this Message

Dave Peterson - 24 Nov 2006 12:33 GMT

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.

> Hello everyone,
>
[quoted text clipped - 15 lines]
>
> Kindly regards..

Signature

Dave Peterson

Reply to this Message

Juke - 24 Nov 2006 15:16 GMT

Kindly regards, thank you very much Dave Peterson.

> You may want to look at using an addin that would be available for each workbook
> you open.
[quoted text clipped - 21 lines]
> >
> > Kindly regards..

Reply to this Message