Card Reader to excel move down one cell after Read

[joepro7]

Hello,

I am trying to get my new RFID Card reader to scan Card IDs into excel. I essentially want to scan a card and then be able to scan the next card in the cell below (next empty cell). I wrote VBA code that when Target cell is changed it runs "ActiveCell.Offset(1, 0).Select" so that it should move down one cell. I am able to get my reader to write into excel, but when it does it as if i am still typing into the Target cell. I thought it would behave similar to a copy paste where it would trigger my VBA code to move down, but it doesn't because excel thinks I am still typing. How can i get my code to trigger to move down one cell?

Thank you, hopefully this was clear enough to understand if not I can provide more details.

[Bernie Deitrick]

When trying it integrate third party hardware, it is best to contact them directly. Their code should handle all of the required actions to populate Excel sheets.