How to link the list of comboBox into Another Sheet When you click ???

[jasond1992]

How to link the list of comboBox into Another Sheet When you click ??/ Like i have list in my ComboBox example (Sheet1,Sheet2 and Sheet3 ) When I Choose SHeet2 and Select It will go the Sheet 2. Thanks for your Help

[Trebor76]

Hi jasond1992,

This will select the sheet selected from the entries in a combo box named ComboBox1 (change to suit):

Sheets(Me.ComboBox1.List(Me.ComboBox1.ListIndex)).Select

You do know that you can get a full list of all the visible sheets by right clicking the navigation bar at the bottom left-hand corner of the workbook right?

Regards,

Robert