Question for the gurus.

  • Thread starter Thread starter renegade X
  • Start date Start date
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?
 
In tools=>Option=>Edit Tab, under Move Selection After Enter, do you have
Down selected?
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Relative Macro 6
repeat calculation for different combination of input? 11
Referencing a cell even if its contents are moved moved/replaced 6
Skip Reference Sequences during copy 3
Combining Text From Cells 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
VB Coding 1
How to change the year digit? 4

Back
Top