title: To detect and trigger event - Excel
body: <p>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.</p>
  
  <p>So I have made an excel macro. And when the barcode is scanned, the text appears on the cell ending with the <code>new line</code> character (text+"\r\n" is provided by the scanner itself). So an event is triggered and does the rest.</p>
  
  <p>The problem is that the event is only triggered with a new line character. What if the barcode scanner didn't provide <code>\r\n</code> after every barcode output. How do I deal with such situations?
  How do I detect it and trigger event?</p>