Userform Textboxes values passing to a listbox

[NDMDRB]

Hello,

Please I need your help.

I have the link below for my shop workbook "example workbook" that contains a userform to manage my invoices

I'm stuck in the following steps and don't know how to solve them, and need your help if you may

• In TextBox "txtBarCode", If I search for an item by "Barcode Scanner" then run the "txtBarCode Change Event", but in case I need to enter the Barcode manually change the code event to "After Update"

• Then If the item exist or not (I have a code to lookup the values and put them on TextBoxes, but I need them in the list box)
  • Add the values to ListBox1 that contains 6 columns (Num / Barcode / Item Name / Unit Price / Qty / Amount) as header
    • Row1 Column"Num" = Count the entered rows unless the header
    • Row1 Column"Barcode" = txtBarCode
    • Row1 Column"Qty" = txtQty
    • Row1 Column"Item Name, Unit Price, and Amount" = lookup values reference to the entered Barcode (same code that I have)
    • Next item add to next row...

• If I need to search by name, I tried the lookup code as on "txtBarCode" with "After Updat Event" but it didn't work
  • I need to check if the entered name is exist or not (the same as on txtBarCode)
  • In case the item exist, lookup the Barcode of this item and put it in txtBarCode

• On Submit button, add the list box values to sheet2 (check the last empty row)

Here is the link for the workbook file
https://drive.google.com/file/d/1mW-H6tsO4yjfIHNIBdS8cIm8sSA5KlL8/view?usp=sharing

 

[NDMDRB]

Any help!