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,
Bookmarks