Barcode scan to pull product data into VBA userform?

[AD4GC]

​I have pulled my hair to no ends scouring the web for hours trying to save this post.

I have an Invoice workbook, and the "UPC-SKU" sheet that has barcodes, descriptions, prices, tax specifier, and inventory qty. I already have two vba userforms, userform1 to add new products and userform2 to update only the inventory qty of a specified item when the barcode is scanned. What I want is to create a third named userform3, it will look exactly like userform1, but instead of it adding new data to the sheet, I need it to search the list, find the barcode and populate the userform with the data from the barcode and then let me update the sheet with changes made in userform3.

I know this should be possible, I'm just not sure how to make it happen, I have spent most of the past two days piecing different segments of code together hoping to get something to work, but so far nothing.

I think I have attached a drastically deflated version of my big Invoice workbook.
InvoiceTEST.xlsm

[ByteMarks]

Rather than have another userform, you could just modify Userform2 so that if the barcode exists it updates, if not it adds.
E.g. as attached.

[bakerman2]

Or with a third userform as requested.

[AD4GC]

Rather than have another userform, you could just modify Userform2 so that if the barcode exists it updates, if not it adds.
E.g. as attached.

Phenomenal! Exactly what I was thinking of and hoping for! This will save me many hours of manual 'Ctrl+F' searching to update products!

Thank you so kindly!

[AD4GC]

Or with a third userform as requested.

Thanks for the work and reply. However, after trying both yours and ByteMarks' version, I do believe his fits my need better.

Thanks

[ByteMarks]

You're welcome