Is there a fromula for TAB?
 

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

Is there a fromula for TAB?
 

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

or look at SendKeys

--
Regards,
Tom Ogilvy

"Bill Maxwell" wrote in message
...
I'm trying to setup a barcode scanner and I wanted to see if excel has a
formula to TAB when inputting data.

Is there a fromula for TAB?
 

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

HTH

"Bill Maxwell" wrote:

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

Is there a fromula for TAB?
 

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" wrote in message
...
ActiveCell.offset(1,0).Select
of
ActiveCell.offset(0,1).Select

or look at SendKeys

--
Regards,
Tom Ogilvy

"Bill Maxwell" wrote in message
...
I'm trying to setup a barcode scanner and I wanted to see if excel has a
formula to TAB when inputting data.

Is there a fromula for TAB?
 

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).

--
Regards,
Tom Ogilvy

"Sharad Naik" wrote in message
...
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" wrote in message
...
ActiveCell.offset(1,0).Select
of
ActiveCell.offset(0,1).Select

or look at SendKeys

--
Regards,
Tom Ogilvy

"Bill Maxwell" wrote in message
...
I'm trying to setup a barcode scanner and I wanted to see if excel has
a
formula to TAB when inputting data.