asked on

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-

ASKER CERTIFIED SOLUTION

krishnakrkc

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Norie

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

RWayneH

ASKER

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-

Norie

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

Kris

When I tried your workbook the combobox seemed to get 'stuck' sometimes.

RWayneH

ASKER

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-

RWayneH

ASKER

Thanks for the help!!