VBA Search Across ALL Sheets, display results. What am I doing wrong?

Good afternoon everyone,

i created a workbook which has individual sheets for specific product types, and then added a module for a table of contents, and another to take me back to the table of contents from each sheet. I am attempting to put a 'search' button, which will allow me to search by part number, displaying a lost of results that will show the part number, description, and data sheet link. I have followed several youtube videos, but I cannot seem to get it working.
Could anyone take a look and offer advice/help? (file attached)

Thanks,

Joe

Originally Posted by PCI

See next code

Please Login or Register  to view this content.

Ahh. Thanks. I thought that was where the searched data would go, not where it was coming from.

So I was hoping to be able to display the entire rows that are matching across all columns. The below is what i am currently getting with this code...

Attachment 746434

This is what i was hoping to see....

Attachment 746437

What would I have to change for this to happen?

Originally Posted by PCI

If it's OK mark thread as solved

Could you please read my comment below this one?

Originally Posted by PCI

So what's the news with the new code ???

I just saw your reply. I’m driving 2 hours to work this morning and will try it when I get to my desk. Thanks so much.

Thank you! Out of curiosity, If i wanted to be able position this on the page (example, D9 as the starting point) what code would i use?
It is fine as is, but I am trying to learn...