Stock management using barcode scanner, Excel, and VBA

Hi everyone,
I'm trying to create an Excel sheet, using the newest Office 365 version, to list and manage the stock level of consumables used at my company. The idea is that all items are listed in a sheet, with a numerical code for each item, and the current stock level. The code for each item will be printed as a barcode on the shelf with the item in the store room, when an item is taken from stores the barcode is scanned and this will automatically reduce the current stock level value of this item by 1.

The process seems relatively simple but I have no experience in using VBA and I've already promised my new boss I can make it work, so now is the perfect time to learn how to do it. The Excel sheet with the list on is already created and so it is just the implementation of the barcode I need to work on. Does anyone have any advice or places I can look to find a way to make this work? thank you for taking the time to read this and thanks in advance for any help you can give me.

.
Do a search on this forum using the terms : bar code inventory

The basic search field is located in the upper right corner.

There are a number of excellent past threads with discussion and sample files. Those should get you started, very well, in the right direction.

I'm doing at now. It's so hard haha. I stuck in setfocus not work. ToT

Hello, im really new to this (VBA) and dont understand much of it but i found your template really handy. one question, at the moment it only works as long as the SKU# is consisting of only numbers? is it possible to change this so i can use barrcodes that use letters as well? Lke X0019EQQ... etc? Thanks a lot!