Search for several values and highlight the row where they are located

Hello All,

I'm looking for help creating a macro, This is what is required:

In my excel document there will be several columns with information, for example: in column A there will be numbers

A
22
43
66
88
95

1 - When the macro runs I would like to appear a search box saying (Please enter the values) where I can put several numbers to be searched on at the same time (Ex: 22, 66, 95)

2 - Once I click on (Search or Enter) I would like that the rows where the numbers are located get highlighted.

3 - If when I do the search the rest of the rows that are not required can be hidden or just show the once from the search it will be helpful too.

Thank you so much in advance. Please Help

Does this help?

Please Login or Register  to view this content.

Thank you John for the quick response.

It worked but there is something when I do the search that is not working properly, maybe I'm doing something wrong.

these are the numbers I have in column A

2
5
22
42
55
62
43
82

When I run the macro I search for these 2 values: 55, 22

instead of just displaying those 2 values only, it will also include the number 2 and 5, also no matter the search you do the number 2 is always there.

Is there a way this can be fixed in order to see only the values enter in the search box

Thanx