ComboBox case select one of 9 or so words to a specifc cell on a different worksheet

[RedBorg]

I have a workbook that contains 5 sheets (Sheet1-Sheet6). I created a combo box on sheet1 that has 1 blank cell as a default, and 9 word choices. I need to write a VBA code that when a user selects one of the 9 different words, it will then take them to a specific cell on one the other sheets. As an example: They chose Apple in the ComboBox1, it will take them to sheet2 A18. If they chose Orange, it would take the user to sheet 3 G54.... I would like the comboBox1 to return to the Blank the next time that workbook is used. I may also need the code to send the user to a separate workbook and certain cell, based on their selection. Thanks for any help with this.

[zbor]

This thread is closed and opened in Commercial Services subforum