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.

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

or look at SendKeys

--
Regards,
Tom Ogilvy

"Bill Maxwell" <[email protected]> wrote in message
news:Op$Wn4M%[email protected]...
> I'm trying to setup a barcode scanner and I wanted to see if excel has a
> formula to TAB when inputting data.
>
>
>

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

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" <[email protected]> wrote in message
news:O9OapBN%[email protected]...
> ActiveCell.offset(1,0).Select
> of
> ActiveCell.offset(0,1).Select
>
> or look at SendKeys
>
> --
> Regards,
> Tom Ogilvy
>
> "Bill Maxwell" <[email protected]> wrote in message
> news:Op$Wn4M%[email protected]...
>> I'm trying to setup a barcode scanner and I wanted to see if excel has a
>> formula to TAB when inputting data.
>>
>>
>>
>
>

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" <[email protected]> wrote in message
news:OOv0VKN%[email protected]...
> 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" <[email protected]> wrote in message
> news:O9OapBN%[email protected]...
> > ActiveCell.offset(1,0).Select
> > of
> > ActiveCell.offset(0,1).Select
> >
> > or look at SendKeys
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Bill Maxwell" <[email protected]> wrote in message
> > news:Op$Wn4M%[email protected]...
> >> I'm trying to setup a barcode scanner and I wanted to see if excel has
a
> >> formula to TAB when inputting data.
> >>
> >>
> >>
> >
> >
>
>