Can I scan Barcodes directly to designated cell columns?

[mxx12a]

So I work at a shop with a rental program we are trying to digitalize. I am pretty good with excel so I created a document that does almost everything I want. What would be nice for it to do that it currently does not is scan items in and out. Best case scenario, when an item is being checked out, I will scan a barcode on the item (barcode would never change), the excel page will jump to that specific items column and populate a date of check out. Then, when the customer returns it, I once again scan that same barcode and it will populate a different cell for being checked back in. One item will always be in the same column, we will just have long lists of costumers who checked it out and back in.

Is this possible? Or at least part of it possible? I know I can scan a barcode and populate a cell with the #s , but can excel jump to a specific cell when I do
I can give a better explanation if necessary.

 

[JumboCactuar]

Bump as im looking for something similar

I would like to scan 2 EAN barcodes (results in Column A and B) then column C to output the current time and then drop to next row.

By default. when scanning the cell drops down as a scan includes carriage return

 

[Tetra201]

@ mxx12a:

Yes, this is possible. From the viewpoint of Excel, scanning a barcode is identical to using a keyboard for typing a string of characters and pressing Enter. So, all you need to do is to develop an Excel sheet where you would type a certain string/number, press Enter, and a certain cell in a certain column would be populated with a date. Such a sheet will work with a barcode reader, too.

 

[mxx12a]

How would I actually go about this though? Is there a step by step or YouTube tutorial you could link as I dont know what to search to find this. But im glad it is possible, we are now making progress!

 

[Tetra201]

I would suggest something like this:
- On a sheet, you would have a single selectable unlocked cell where you would enter/scan in an item ID;
- The entered/scanned-in ID would trigger a VBA Worksheet_Change event sub;
- The sub would find the cells/columns associated with the ID;
- The sub would flip the "in/out" status for the ID and would put today's date/time in the corresponding cell(s);
- The sub would show an "ID XXXX: Status updated" message, clear the ID entry cell, and exit.

 

[danielharmaggedon]

I think I am looking for the same solution.
I want to scan a barcode, whether it be 2d or 1d, and it populate multiple cells. I had a previous scanner that did it automatically and the code was simply two forward arrows, and I cannot recreate this. I am unsure if the arrows are the same, or if it is a double tab arrow, which did not work either. I know there is a method to "tab" to the next cell, although, it may truly've been the programming of the 1d scanner i did have. I am attempting to recreate it on my new 2d scanner from Netum. Any development on this yet?