Barcode Scanning to bring up specific userform that allows you to edit qty in the userform

Hi All,
I trust you are well.

So I have a Stock Management System which uses a barcode scanner, once barcode is scanned it looks up the value and adds it to the specific product line on the sheet, which then pulls through to the relevant stock report for each week as we do weekly stocktakes.

Now I need a code on the sheet to call a userform if a barcode's first 2 digits equals to a specific number, On the userform it should automatically call up the barcode, product name and a space for new weight ( we are in the food industry) It then needs to place the value in the userform into the relevant corresponding space on the sheet.

IE. Scanner app week 1 is where all the data needs to be posted. The sheet already looks up the value and automatically posts 1 next to the corresponding barcode row, however if the product barcode starts with a 26,21 etc it needs to bring up a userform that allows you to input a weight to the corresponding product row.

I hope it makes sense

I have attached a sample of the spreadsheet

Thanks in advance!

title updated, thank you...

Hello ChefThys,

It is not possible to test the workbook properly due to a missing reference to the workbook "excel-inventory-management-template(1).xlsm", the QTY column of the INVENTORY_MASTER worksheet shows a #REF!. Please post the other workbook so we can provide you with a working solution.

Hello ChefThys,

Thank you for taking the time updating the workbook.