I am looking for a way to for an cell in Excel to automatically change to the
next cell one row below, upon population of the cell. I want to scan a
barcode into a cell and without hitting enter, have the cell automatically
move to the next cell and be ready to recieve another scanned barcode. Thank
you,

Bill see the "Worksheet_Change" event on Chip Pearson's site--follow
this link:

http://www.cpearson.com/excel/events.htm

HTH--Lonnie M.

Without hitting enter? If this is the case, it will still be in edit mode,
so it can't go anywhere (unless you exit some other way such as tab).

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill" wrote in message
...
I am looking for a way to for an cell in Excel to automatically change to
the
next cell one row below, upon population of the cell. I want to scan a
barcode into a cell and without hitting enter, have the cell automatically
move to the next cell and be ready to recieve another scanned barcode.
Thank
you,

Bill,

Most scanners can be configured to append a terminating character (such
as enter or tab) to each scanned barcode. Take a look at your scanner
documentation on how to enable that.

Alek Szymanski
http://www.barcodewiz.com


Bill wrote:
I am looking for a way to for an cell in Excel to automatically
change to the
next cell one row below, upon population of the cell. I want to scan
a
barcode into a cell and without hitting enter, have the cell
automatically
move to the next cell and be ready to recieve another scanned
barcode. Thank
you,