change of cell upon cell change

[Guest]

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,

 

[Lonnie M.]

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

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

HTH--Lonnie M.

 

[Bob Phillips]

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)

 

[barcodewiz]

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