Combo List with a Macro

Hi

I am trying to create a combo list that when the user makes a selection and clicks on a button, it takes him to another sheet.
e.g worksheet 1 is called "year 1" and worksheet 2 is called "year 2". When the user selects year 2 from the drop down list and then clicks on a button, it takes him to year 2 (worksheet 2).
Any help would be much appreciated.

Hi there,

Have a look at my attached solution which (hopefully) meets your needs.

HTH

Robert

Many, many thanks Trebor76, that is exactly what I was looking for.