Find order and populate userform with the data from a sheet

I had to duplicate this thread as for some reason I cannot access the previous one, maybe moderators can delete the first (http://www.excelforum.com/excel-prog...-userform.html)

Hi all,

Could somebody please help me with the code for the userform.

I have a userform with the search button, I would like to enter the unique order number in a textbox and after pressing the search button the code will search for this order number in a worksheet and if found will populate the userform fields accordingly.

I have attached the form below.

Would appreciate any help.

Many thanks