Macro from List?

[rufusf]

Hi

Looking for help - I want to run a macro from a list. Let me explain - if i have 5 options on a list 'Sheet A, Sheet B, Sheet C, Sheet D, Sheet E' - What I want is when you select an option from the list then a macro takes you straight to that sheet...

Any ideas?

Many Thanks !!

[raypayette]

If you already have an Option box, simply assign this macro to it:
Sub CheckBox1_Click()
Sheets("Sheet2").Select
End Sub