VBA to Search for Multiple Values in a column on a specific sheet

[LKERN]

I have a sheet with a list of items. I want to create VBA to bring up a search box that asks them what to search for and then either list all of the items and their cell reference OR (preferably), highlight the items in the list.

I found the following code on another site, but it only lists the first instance that it finds AND I don't like the way it lists it in the same search box. I would prefer that it highlight within the list, jump to the location, or at a minimum, show a message box with the location of the items.

Please Login or Register  to view this content.

Any help is appreciated.

[Akuini]

I don’t quite understand this part:

AND I don't like the way it lists it in the same search box. I would prefer that it highlight within the list, jump to the location, or at a minimum, show a message box with the location of the items.

But see if this works as you want:
This will highlight the found items with yellow.

Please Login or Register  to view this content.

[LKERN]

This works perfectly! Thank you!

One thing I didn't consider is that I don't want the cells to stay yellow indefinitely. I decided to add a button with a macro to clear the highlighting.

Would there be a line I could add to the code you supplied, to remove any highlighting that is already there if the user runs the code again without pushing the button I created to remove it?

[Akuini]

Just add the blue line:

Please Login or Register  to view this content.

[LKERN]

Perfect. Thanks again!