I am working with excel (2007) and the files that I work with have a lot of sheets. I am finding it difficult to scroll through them to get to the sheet that I need to jump to.
I am thinking about a combo box that has a list of the sheets in the workbook poping up when I hit a key so that I can select the sheet that I want to go to. It would be good if the combo box has an "Autocomplete" feature.
Can anyone let me know how this can be done using VBA? I am a java programmer but I have no experince with VB.

Thanks a lot in advance.