Combo Box To Jump Between Sheets

**vivek_1612** · 10-16-2007, 10:36 AM

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.

**royUK** · 10-16-2007, 10:42 AM

There is some example code here

http://www.excel-it.com/vba_examples.htm

**VBA Noob** · 10-16-2007, 10:46 AM

vivek_1612,

Please read forum rules below. Cross posting is not permitted without including the link. Please add the cross post link or thread will be closed

VBA Noob

Combo Box To Jump Between Sheets

LinkBack

Thread Tools

Display

Combo Box To Jump Between Sheets

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions