dropbox to search tab/sheet and go to

[ronettes]

Hi Gurus

I am not satisfied with my efforts, I have tried various codes, but does seem to do what I need.

In the Recipe tab, I have a macro to create a new recipe and then it opens a tab with the recipe name, then we select the ingredients and al that. But soon I will have like 50-100 tabs of recipes, then sometimes have to update them, and don't want to page through all the tabs.

I would like the dropdown box (in Blou blocks) to narrow the search while I type, and when I get to the tab I need, I would like to click on it and be navigated to that sheet.

eg: if i type Chicken it should show all the sheen names containing chicken, then I select one.

IS THIS POSSIBLE - I don't like the Hyperlink Idea!

[Akuini]

Try this:
Hit enter to go to the intended sheet.

[ronettes]

Try this:
Hit enter to go to the intended sheet.

Ahh Thanks - already makes my life easier. Thanks

[Akuini]

You're welcome, glad to help, & thanks for the feedback.