Find tab

[Salamullah]

Dear experts,

I have excel file contained more than 100 Sheets "Tabs", is there any option to find specific tab instead of dragging the pointer ?

Regards

 

[MARK858]

Right click one of the navigation keys and you should get a dropdown with all the sheet's listed.

 

[Salamullah]

Many thanks MARK858, it will be good if any option available same like finding any cell or word with ctrl+G and ctrl+F.

 

[MARK858]

As far as I know (top of my head) then you would need VBA to do that (using an input box) and I am only on my phone at present and so can't post code for that.

 

[Salamullah]

ADVERTISEMENT

No hurry, when you get time please send code.

 

[My Aswer Is This]

A Input Box script would work if you know the exact name of every sheet and want to enter that sheet name in an Input Box. Do you think that would work?

 

[MARK858]

A Input Box script would work if you know the exact name of every sheet and want to enter that sheet name in an Input Box

If that is a concern then you could populate a list box with the sheet names and use that (but then you might as well use the dropdown already described).
On my phone only for the rest of today so if anyone wants to contribute code in response to the OP etc. feel free.

 

[My Aswer Is This]

If you have a "Master Sheet" where you are always navigating "from" we could put a ActiveX combobox on the sheet and you could choose what sheet you want to go to from the Combobox.