Macro for Message box to return adjacent cell value of all the matches in a column range

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

Maybe:

Please Login or Register  to view this content.

You're welcome. Glad to help out and thanks for the feedback. Refer too the rules link and mark this thread as SOLVED.

http://www.excelforum.com/forum-rule...rum-rules.html