how to make the barcode reader trigger a macro in excel.

[CSL]

Hi,


Can anyone please give me some information on *how to make the barcode
reader trigger a macro in excel*. In other words, after the barcode
reader registers a barcode it will execute a macro.

Thank you for your time and help.

 

[Tim Williams]

You could try using a sheet-level event to trigger the macro: I guess it
depends on how the data is entered by the reader.
Eg: if the entry leaves the sheet in "edit" mode then macros will not run in
that state.

What is the cursor behaviour when you scan a barcode? Does it advance to
the next cell after the read?

Tim

 

[CSL]

Hi Tim,

the cursor advance to the next cell after the read.

 

[Tim Williams]

Then you should be abble to use a "change" event procedure in the sheet
module to trigger your code.

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

Tim.