|I don't know anything about what happens when you use a bar code scanner, so maybe you could explain that part. Does it put a value in a cell? Is it always the same cell?|
If that's what it does, then it's possible that a Worksheet_Change macro might work. If the macro was monitoring a specific cell, e.g. A1, it could run each time A1 changed and search your list for the new value in A1 and highlight it.
Does that sound like it would work?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.