Question for the gurus.

R

renegade X

How can I make my spreadsheet automatically jump to the next cell when I
scan into it? The input comes from a scanner, patched into the
keyboard, that reads bar codes. I want to scan into cell "A1", then
have the cursor move to cell "B1". And after the data is entered into
cell "B1", the cursor drops down to "A2".

I know this has to be a simple command.:confused:

Anyone have a clue?
 
T

Tom Ogilvy

In tools=>Option=>Edit Tab, under Move Selection After Enter, do you have
Down selected?
 
R

renegade X

Hey, that's cool! However, my problem is cut into half.
Now that it enters to the right, how do I make it drop down, so the
send keys will go right, then down?
I probably need some VB codes.
 
R

renegade X

I do not see a function for FOR/NEXT, is this something that I will hav
to code in the VB editor? I think this statement will work. How do I g
about trying this
 
Top