VBA and Excel Sheet Tabs

I have a huge spreadsheet that has a ton of sheet tabs.  Has anyone written a userform that would place all these sheet tabs in numeric order, so I could begin typing the first few numbers of the sheet tab and it would sort the list down as I get to the forth or fifth character it would be there to select?

Of course after selecting it, it would goto that sheet and home the cursor to A1?  I have seen these before but did not have a use.. go figure now I have a need.

Please advise and thanks. -R-
Who is Participating?
krishnakrkcConnect With a Mentor Commented:


NorieConnect With a Mentor VBA ExpertCommented:
You don't need to sort the sheets you can just list the sheets in a combobox and type the name.

As you type you'll see the combobox sort of 'autocomplete the sheet name.

Once you have the one you want press a command button.
RWayneHAuthor Commented:
THANKS!!  I like the first userform example, because it allow you to see the different sheet as you are typing them in.  It would be nice if when I press enter that it goes to the sheet instead on having to use the mouse..  -R-
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

NorieVBA ExpertCommented:
You can do that by setting the Default value of the command button to True.


When I tried your workbook the combobox seemed to get 'stuck' sometimes.
RWayneHAuthor Commented:
I noticed that too, but it appeared to get stuck only when you have reached a sheet tab name limit..  and you begin typing in a invalid sheet name..  Now I am liking the second example.

heck, I like them both.  Thanks for the two examples!!  -R-
RWayneHAuthor Commented:
Thanks for the help!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.