Is there a fromula for TAB?

[Bill Maxwell]

I'm trying to setup a barcode scanner and I wanted to see if excel has a
formula to TAB when inputting data.

 

[Tom Ogilvy]

ActiveCell.offset(1,0).Select
of
ActiveCell.offset(0,1).Select

or look at SendKeys

 

[Guest]

You might be able to use vbTab which inserts a tab character. Depending on
what you want...

HTH

 

[Sharad Naik]

OR in That worksheet,
In Worksheet_Change event
add
Target.Offset(0, 1).Select
Or
Target.Offset(1, 0).Select

This way in your code you can keep referring to ActiveCell

Sharad

 

[Tom Ogilvy]

another thing to look at is in

Tools=>Options=>Edit
Look at your move selection after edit setting. If it is not checked, you
need to check it and then select either down or right. I have never used a
bar scanner with excel, but if it is simulating keystrokes, then it probably
sends a return after entering data in each cell. If you set the above to
down, you shouldn't need to have any coding. (just a guess of course).