Automating the Enter Key once text is scanned into cell

Enchantix

New Member
Joined
Sep 20, 2015
Messages
34
Hello guys,

I have a frustrating problem that I really need help on. Im using a user form in excel and integrated a Bluetooth barcode scanner which I scan barcodes into a text box.

once the information is scanned into that text box the information goes into another text box below.


The problem is on occasions when the barcode is scanned the text remains in the first text box and doesn't move down to the next text box below until the enter key is pressed.

is there a reason why it would do that? Maybe the length of the barcode?


any help would be greatly appreciated.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
It could depend on the barcode language, but my experience is tab and enter are part of the barcode (after the rest of the information stored). Where it is not pressing enter it's possible the command isn't in the barcode.
 
Upvote 0
it depends on the barcode reader you're using, it should have pressed the Return or Tab key for you.
 
Upvote 0

Forum statistics

Threads
1,223,901
Messages
6,175,277
Members
452,629
Latest member
SahilPolekar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top