Scan in DATA using a FORM

[Tobievr]

I urgently need help please. It seems when it comes to scanning in data using a form, it becomes tricky.

I have two input boxes (column 1 & column 2). When one number is scanned (Input Box 1) it must automatically write to the cell A1, TAB to (Input Box 2) it must automatically write to B1, and repeat until done. What I cant figure out, is to make it write automatically to the cell without having to press a button after each scan. Please can someone help me.

Thanks

Tobie

[royUK]

This is probably something to set in your scanning software

[Tobievr]

Unfortunately the scanner gets used on to many other applications and cannot be set via its software, that is why I was hoping it could be done with some Excel Programming. Any other thoughts by any chance please.

Thanks

[royUK]

What exactly are you scanning?

[Tobievr]

There are 4 Colums:

1. Quantity - This input will be once, but must appear in sequence (1-20 example)
2. CT Number - CT12345
3. CPUT Number - CPUT98765
4. PS/CT Number - This number is one time entry

But number 2 and 3 need to be next to each other used for cross reference.

I hope this helps.

Thanks

Tobie