Member Avatar for purijatin

I have a barcode scanner. So when the barcode is scanned using a gun, the value normally is entered to textfield placed on the screen.

So I have made an excel macro. And when the barcode is scanned, the text appears on the cell ending with the new line character (text+"\r\n" is provided by the scanner itself). So an event is triggered and does the rest.

The problem is that the event is only triggered with a new line character. What if the barcode scanner didn't provide \r\n after every barcode output. How do I deal with such situations? How do I detect it and trigger event?

  • 2 Contributors
  • 1 Reply
  • 104 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by adam_k
Member Avatar for adam_k

I'm not sure how you can trigger an event with the CRLF. My guess is that you are using the Worksheet_Change event and in that you verify if the newly entered text ends with \r\n. If this is the case you could remove this test - BUT be warned that this will cause your trigger to fire with every change, including when your macro does stuff like clear the value from the worksheet, causing an infinite loop.

Can you share details on what you are doing with this macro - and possibly the macro itself? Perhaps there is an alternative.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.