Hello Excel Forum Folks!!

Please help me with the macro for user form,

I need a message box macro which has to search and show adjacent cell value of all the matched value in a range.

It would be great for me if anyone can reply.

Emp ID Emp name Seat ID
102 AB 2
103 BC 3
104 CD 4
105 DE 2

if search value is 2,
Show all the Employee ID and Name in a message box if seat no matches.


Thanks,
Saranya