Entering data and then moving to another cell after data has been entered

[Andrew Johnson]

I am new to the vba / macro side of excel and am trying to work on a solution to a process we are currently streamlining. I have created an excel workbook, on just one sheet, where we are scanning in data with a hand held scanner. For the example sake, the first scanned number goes into B11, what I would like to do is after that 10 digit serial number is scanned in, I would like the cursor to go to B12 for the next entry all the way down the sheet to B35. I am not sure if a form is the better route to go but a macro seems to make more sense.

Tia,
Andrew

 

[HalfAce]

Hi Andrew,
I haven't used a scanner to make entries in Excel before, (though I know some folks who do), so I'm only guessing that when a scanner makes the entry, it's viewed as a worksheet change.
If that's the case then we can use the worksheet change event to trigger the code to drop down one row after each entry.
Try right clicking on the sheet tab and choose 'View Code'.
Paste this into the code module for the sheet that opened up.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B11:B35")) Is Nothing Then Target(2).Select
End Sub

(Press Alt+Q to close the vb editor and get back to your sheet.)
Give the scanner a try and let us know if a scanned entry executes the code.
(If it does, this should work.) The question then is what do you want it to do when it reaches row 35?

Hope it helps.

 

[Andrew Johnson]

I entered the vb code, great instructions by the way, but alas, nothing. As for the end, that would be the max of the serial numbers that need to be scanned. (fingers crossed) I will test again when I get home later.

-Andrew