sending user to worksheets based on combobox selections

[Amy DeLuca]

Hoping you can help...

On sheet 1 the user makes 2 different selections from 2 different comboboxes. Can the command button send the user to worksheets based on their selections? The names of the worksheets do not coincide with the combobox selections.

The selection they make in the 1st combobox needs to make them go to one sheet and the selection they make in the 2nd combobox needs to make them go to another.

Thank you sooo much in advance for your help!

Amy

 

[zacemmel]

Private Sub ComboBox1_Change()
sheet1.select
End Sub
Private Sub ComboBox2_Change()
sheet2.select
End Sub

Is that what you are talking about?

http://www.excelquestions.com