Macro that Finds and Goes To the First Matching Worksheet Name Based On User Input Box

Good Morning All,

I can't help but think that there has to be an easy fix for this. I have a workbook with 500 sheets - one for each employee's attendance card. (I know that Excel is not the optimum program for this, but have to work with it).

I need a macro or VB script that does the following:

1. On button click, opens a user input box that says "Enter Associate Name"
2. Once the user submits, it looks across all the worksheet names, and activates the first worksheet that meets the string entered, leaving the input box open. If the user clicks cancel on the input box, the macro stops. If the user clicks OK again, the next matching worksheet is activated, and so on.

I am new to VB programming and could really use a hand. I know you can use the CTRL F search and select "Search Entire Workbook", but this means an extra few steps for every search.

Many thanks,
HRGoddess

Maybe?

Please Login or Register  to view this content.

Works like a charm, thank you so much!