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

  • Thread starter Thread starter CSL
  • Start date Start date
C

CSL

Hi, :confused:


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