vba code to search for a serial nr

I need help with vba code to search for a serial nr, on Sheet1 I have a search field in the row N5 and a form button when I enter the serial number in the N5 and press the button I want it to find the seral no. and highlight it and the row on sheet2 where i have all the data on that serial no.
can someone help me with that?

Easiest way would be this :

Please Login or Register  to view this content.

This highlights the cell yellow on sheet2 that has the same value as sheet1 N5
Is this what you're looking for?

Please click on the * below if this helps

Thanks but not quite how I wanted it, I want it to go to sheet2 and select the row with that value I'm searching for

thanks this was exactly what I was looking for, appreciate your help