Combo Box help

[cortezz]

Hi There

I need some help. (Please)
I have created a combo box with multiple listing in it.
I would like the user to select one of the listings from the combo box and according to the selection, it must jump to a section in the sheet.

Example: Combo box has 3 listings: (Sheet 1, sheet 2 and sheet 3)
When they select sheet 2 from the combo box. Excel must jump to sheet 2.

I hope this makes sense.

Many thx

 

[rs2k]

Welcome to the board,
Is the combo box on a userform or on a work sheet?

Colin.

 

[cortezz]

Hi. Colin
Thank you.

I have the combo box on a work sheet. Sheet1 has the combo box on and my listings for the combo box is on sheet 2.

Sorry if I don't make sense, I am new to this.

Thx

 

[rs2k]

An easier way would be to use buttons. And record a macro to take you to the required Sheet or Cell. If this option is OK and you don't know how to do it post back. I will have a look at the list option though.

Colin.

 

[cortezz]

Hi Colin.

Thx. I have used the buttons before, but would really like to use the combo box for this one.

Do you have any ideas?

Thx