• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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-
0
RWayneH
Asked:
RWayneH
  • 3
  • 2
2 Solutions
 
krishnakrkcCommented:
Hi,

PFA.

Kris
GotoSheet.xlsm
0
 
NorieVBA 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.
UFGotoSheet.xlsm
0
 
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-
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
NorieVBA ExpertCommented:
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.
0
 
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-
0
 
RWayneHAuthor Commented:
Thanks for the help!!
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now