Vlookup On A Userform With Textboxes

Hi! I am trying to make a userform where I enter a barcode in TextBox1 and as soon as I enter the last digit, I want its corresponding Item Name to be displayed in TextBox2,3,4.
And after enter a scan date(TextBox5), Click in the IN button(ComboBox4) to add the data to the next empty row of Sheet("In"), Click in the Out button(ComboBox5) to add the data to the next empty row of Sheet("Out").
I already have an Excel sheet that can be used for a Vlookup function but I do not know how to apply it as a Visual Basic code in the userform. How do I go about this?

I'd really appreciate any help.
Thanking you in advance .... it will indeed be appreciated.
Kind regards,

I added this code to userform:

Please Login or Register  to view this content.

Regards,
Antonio

Hello! With your help I had great luck with my workbook. Thank you

I'm glad that you fixed your problem.

Regards,
Antonio