Setting focus back to textbox after cell populate for next entry

Hi All

I find that selecting a cell and then scanning barcodes, enters the value into cell, then moves down to next cell automatically.
How can I achieve this though userForm textbox scanning. i.e

Scan into textbox and then automatically have scanned item appear in cell then clear textbox and scan next one etc etc etc

K. so got that part working for first initial scan....Trying to get the textbox to set focus after the update but not able to.

Here is code...Any ideas

Please Login or Register  to view this content.

Edit2...

I noticed that after scanning the next tab index is triggered which is a command button so I inserted the setfocus code within, however, no I have to scan twice to trigger the setfocus code...

How am I able to set the focus back after update??


Edit3...
Figured it out....

Please Login or Register  to view this content.

NOOOOOOO

Now I can't do anything else until I cancel the code....

Any one perhaps have a solution for me...have searched the web to no avail...

Try TextBox27.Select

Hi myou....No go.
Have added

Please Login or Register  to view this content.

to my code and created a fictional hidden command button with tab index set to follow and code within that sets focus...This works however, it changes every second scan to proper text and not upper as should be...

O.K.

What about;

Please Login or Register  to view this content.

Tried that as per Post2....Does not allow code to exit...
This solution has worked...And then hidden commandbutton with setfocus code....

Please Login or Register  to view this content.

Not gonna mark as solved just yet as there are multiple instances on web without results...

Hi All

Wondering if anyone has a better solution for me....

Any ideas from this from another project using textbox_Change

Please Login or Register  to view this content.

Thanks NoSparks for response, but not...

What controls do you have on the form?

meaning....Controls from toolBox

Yes- which ones are on the form? Just the textbox and button, or any others?

Have uploaded sample...Thanks for taking time to hAve a look.

I don't have a scanner but perhaps this

Please Login or Register  to view this content.

that would allow you to exit the textbox as long as it's empty?

You are a genius xlnitwit....that is perfection...thanks so much...Can't spread any more +++++