How to run a macro on sheet change with auto clear of the cell and not creating a loop

Hello everyone, this one has stumped me pretty good.

What i am doing is locking down an excel sheet and leaving one 1 open cell available. I then use a barcode scanner to scan in a barcode into that specific cell (B3). I have a chunck of VBA that will copy that cell data to sheet2 and put a time stamp with it for logging purposes. I also have a command button that does an auto print to print the new barcode and then it clears the data out of B3.

What I am trying to do is not have to use a command button. When I scan in the barcode, i want it to print it automatically and then clear the data out of cell B3.

I put my chunk of code that does the auto print and cell data clear into a Worksheet_Change but what happens is they fight eachother. When i scan in the data it acts as a sheet change, and then when the macro runs and i clear the data it also acts as a sheet change. So it just sits there in a loop of printing and clearing the cell data over and over and over and over again untill i have to manually close the excel sheet. It would never end!!!

Any help with this would be greatly appreciated!!!!!!

If I turn off the event handling to stop the event change then the macro won't run. I need the sheet change to execute the copy of cell data, print auto, and clear the cell, but when the data is cleared it runs the macro again because it causes another sheet change and just keeps going. What will turning off the event handling do?

So I should check to see if cell b3 has changed before I run my VBA?

Alright I will try it out, thanks much!

Well that little bit of VBA didnt work where it checks for B3 range. It just continues in a loop over and over again. Anybody else have any suggestions?