Jacob this is a great code! The problem is and I'm sorry I have not been clear enough, the words I have to search for are in textboxes in the sheets. We type text in textboxes in the sheets. I've tried the code and it's great for finding data in cells but can I adjust it in a way that it can search for words in textboxes?


Thanks for the help.