Prev: HELP!! Formula for calculating overtime
Next: Macros in excel
From: CellShocked on 20 Feb 2010 15:28

So, has anyone turned out a programmed custom function for this type of
thing? Does there exist one in say... Access?




On Wed, 17 Feb 2010 20:21:01 -0800, Archimedes' Lever
<OneBigLever(a)InfiniteSeries.Org> wrote:

>Hey guys.
>
> I want to make a sheet that has a cell in it where I use a barcode
>scanner to grab a barcode.
>
> What I want is for the cell to grab the barcode, and fire it off to a
>specific cell, empty the reader cell, and wait for the next barcode scan,
>which gets filled into the next cell below the previous fill location.
>
> barcode scanners already have no problem inputting the data. The
>problem is that the read barcode does not ever include a carriage return.
>
> Currently, I simply use cursor keys, and advance to the next cell
>manually after each read.
>
> Is there a "wait for entry" monitoring code of some sort that waits for
>entry into a cell, then begins a timeout, then fires the read data off to
>a certain cell? So even if I type into the cell, it starts the timeout
>period, and after that expires, it takes the data, whatever it is, and
>dispatches it to a certain cell other than the capture cell.
>
> Please tell me that this is a fairly easy code segment that someone has
>already churned out.
First  |  Prev  | 
Pages: 1 2
Prev: HELP!! Formula for calculating overtime
Next: Macros in excel