Scan barcode case jump
Solved
PandaZwan
Posted messages
4
Status
Member
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
Hello,
I am using a scanner (gun) from the brand Netum NT_M1,
I would like to know if a macro or a code on my page would allow each scan to move to the next cell?
Because right now I scan the code and it is recorded, but I stay in the same cell for the next scan, whereas I need to have 1 code per cell throughout column A.
Thank you in advance to all of you
Configuration: Windows / Chrome 87.0.4280.88
I am using a scanner (gun) from the brand Netum NT_M1,
I would like to know if a macro or a code on my page would allow each scan to move to the next cell?
Because right now I scan the code and it is recorded, but I stay in the same cell for the next scan, whereas I need to have 1 code per cell throughout column A.
Thank you in advance to all of you
Configuration: Windows / Chrome 87.0.4280.88
2 answers
Hello,
in your scanner settings, you should be able to configure it to add the CR (or CR+LF) character at the end of the scan.
That's what Excel expects to validate the input (just like hitting Enter)
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), please remember to mark it as resolved. Thank you.
in your scanner settings, you should be able to configure it to add the CR (or CR+LF) character at the end of the scan.
That's what Excel expects to validate the input (just like hitting Enter)
eric
--
By continually trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), please remember to mark it as resolved. Thank you.