Search Workbook for Text entered in Embedded Textbox

I'm trying to search multiple worksheets for a Text String entered into an Embedded Textbox, and go to the Worksheet and Cell the data was found in. I've ran across a vlookupworkbook function, but I couldn't understand how to make it work.

Try to put this behind that TextBox. When you click "Return" it starts searching

Please Login or Register  to view this content.

ok, that works, Thanks!
To expand, the data I put in the textbox looks like this AB/WXYZ/123456/ZA. How do I only enter the 123456 in the textbox? Maybe eventually the letters may change, so, if the long string is in it searches that way, and then if only the numbers are in it still works but could pick up duplicates. maybe the built in form that the error message comes back with not found could list the pages the duplicates were found in and I choose which page to go to?

Somehow I fixed this. I changed that 1 to a 2. I'm not sure what that changed. I was reading something about xlwhole or xlpart, and I think the 2 is part.

Please Login or Register  to view this content.

I have a problem, when I do a search for the ID, and if the worksheet is hidden it errors. I have this code that opens the worksheet I choose in the Listbox, but, only the primary of the two worksheets are in the Listbox, and presumably, there will be an ID searched that resides in the secondary sheets.

I can build a table in the Datasheet with the primary and secondary sheet names, primary in column a, and the secondary in column b, so if the worksheet name is in the secondary column to call the worksheet name in column a.

Please Login or Register  to view this content.