Hi all,
I have scenario where every time user scan the barcode into specific column in the Table1, we need the formula (state in the other column) and new row will insert automatically in the Table1, so that next barcode will be key in after hit enter.
Is that possible ? Attached file as below.
Hi,
You could just use TAB to move through each column and a new row will be added once you tab out of the last column?
Why are you using NOW() in the Real Time column? Lots of these will slow your workbook down and they are volatile so I don't see why it is useful to have this here.
Regards
Phil
Hi Phil,
Thanks for your reply. By pressing TAB, it is perfectly works!
However, my current situation cannot apply TAB directly after scanning.
This template will be displayed at monitor where its location is far from the person who is required to perform the scanning.
The person who scan the barcode just scan without required to press TAB.
I was thinking, is that possible if auto insert new row followed with formula after scanning had been done using VBA probably ?
For the second item, formula NOW() being used to indicate the time of scanning being performed. Is there any other option since this formula will slower down the operation 🙁 ?
Regards,
Mariya
Hi Mariya,
You could use events to trigger some VBA to insert a row in the table, but I don't know how your barcode scanning works. The event will only trigger after the data is entered in the cell i.e. the ENTER key is pressed. So how does your scanning work? Once the barcode is scanned, does the focus/active cell change or is there some user interaction required to confirm the scanned code?
Phil
Hello,
Some barcode scanners, for example Zebra, do support change of settings to send a TAB code when scanning. What brand do you have on your scanner?
Hi Phil,
The user will scan the barcode only then the box will automatically move down after scanning. I have attached the video for your reference.
Hi Anders,
I used brand scanner Innatech and Honeywell.
Regards,
Mariya
Hello,
For Honeywell scanners I found this document, see pages E11 and E12.
For Inateck I have not found any info that says anything about setting TAB char as prefix or suffix.
An other option is to change the setting for the specific Excel document so that RETURN makes the shift of active cell to go down.
