How can I create a combo box in Excel so that when I click on a list value it brings me to a worksheet in same workbook? Just like clicking on list value in Name Box on formula bar can bring me to a worksheet for a named cell? Does this require some code? Anyone have that code? I am not a programmer. Thanks

Hi , a little bit of code along the lines of this will allow you to jump to different sheets depending on which value you select from your combobox dropdown list. Of course, you need to have created the combo box on the sheet first. Private Sub ComboBox1_Change() If ComboBox1.Value = "three" Then Sheets("Sheet2").Select End If If ComboBox1.Value = 2 Then Sheets("Sheet3").Select End If End Sub If you're not totally confused , you don't fully understand the question.

Coldpaws, Thank you. I will try this. IpSquared

Hey Everybody, I'm in the same boat. I tried the code, but have not been able to get it working so far. Here is what I got: Private Sub ComboBox_Change() If ComboBox.Value = "R FRONT" Then Sheets("R_FRONT_Hardwired").Select End If If ComboBox.Value = "L REAR" Then Sheets("Audio_1_AZ80").Select End If If ComboBox.Value = "120V-60HZ 4A" Then Sheets("ER_16_PC_100A_Outlet_6").Select End If If ComboBox.Value = "R REAR" Then Sheets("Audio_1_AZ80").Select End If End Sub Any help would be greatly appreciated. All the best, Ian