Need macro to find worksheet...

  • Thread starter Thread starter E. Miller
  • Start date Start date
E

E. Miller

I have an Excel workbook that contains well in excess of 50 worksheets. I
recently had a macro that I found on a website mentioned on this board that
would produce a drop-down list of all the worksheets where I could click on
the sheet needed and that sheet would then pop up as the active sheet.
Unfortunatly, my work computer hard drive had to be replaced and I lost the
macro. Anybody know where I might find this macro or another macro or add-in
that would do the same thing? I would greatly appreciate any help.

thanks

Eric
 
hi
as an alternative....
right click your sheet navigator in the lower left of the screen.
you will get a popup listing the first 15 sheets. there will be another
entry...
"more sheets". cick more sheets and yo will get a pop up text box with
scroll bars
click one to go to it.

Regards
FSt1
 
You probably want something like this? (Sorry, original post not
available)

Sub GoToSheet()
'
' builds a list of sheet names and asks you to pick which one you want
' type in the number to jump to that sheet
'
'
Dim MyShts As Long, MyList As String
MyShts = ActiveWorkbook.Sheets.count

For i = 1 To MyShts
MyList = MyList & i & " - " & ActiveWorkbook.Sheets(i).Name & " "
& vbCr
Next i

Dim MySht As Single
MySht = InputBox("Select sheet by entering its number." & vbCr & vbCr
& MyList)

Sheets(MySht).Select

End Sub

(from: http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm)

HTH,
JP
 
Yes, I am aware of the right-click tool, but the sheets I normally need to
access are on the far right of list of tabs making this option
inconvenient.....

Thanks though for the suggestion.
 
The "VCR" buttons are not very convenient when dealing with 50+ worksheets.
That's a lot of clicking to move through dozens of sheets.
 
What about the second suggestion?

E. Miller said:
The "VCR" buttons are not very convenient when dealing with 50+ worksheets.
That's a lot of clicking to move through dozens of sheets.
Click to expand...
 
My appologies Dave, your second suggestion was exactly what I was looking
for. Guess I need to slow down a little when reading. I appreciate the help.

Thanks

Eric
 
I also like Bob Phillips' browsesheets macro as an alternative to a Toolbar.

http://tinyurl.com/yoa3dw



Gord Dibben MS Excel MVP

My appologies Dave, your second suggestion was exactly what I was looking
for. Guess I need to slow down a little when reading. I appreciate the help.

Thanks

Eric
Click to expand...
 
Back
Top