searching data using a userform

Hi Guys,

I think a simple task, not used to many user forms in the past

I am looking to enter a numeric value these are the green columns.

it then needs to search the workbook for that number (Barcode Number)

then if the cell to the right has a value, it needs to pull that number into the userform' if no number is next to it, then I manually write and post it the cell next to the one just found.......

easy peasy (NOT)

cheers in advance


Stephen