VBA and Excel Sheet Tabs
Posted on 2012-04-13
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-