Validation of Input data - Will VBA work?

Hello, I have a project in which I have created multiple QR codes to be scanned into a spreadsheet to identify when specific tasks are completed. This will occur Monday Through Friday 24 hrs. per day. There is a total of 210 codes and each are unique to a particular line and machine. If a code is scanned in more than once, it will generate an error message to let them know that duplicates are not acceptable. This is where my problem presides. If an error message is acknowledged and the operator clicks OK, it will automatically clear the field and they can re-scan to QR code and it will be fine, however, if they are not paying attention and scan another code without acknowledging the error message, it will clear the error and only enter the latter portion of what the QR code is programmed to do, which will not be identified properly and will not show as being completed.
Example: TIR01-1-PCI is an acceptable entry, when an error has not been cleared, it may only show a partial scan of PCI, which is the last part, but incorrect.
I have tried to utilize Data Validation, but when using a scanner, it will over-write the validation rules. I have looked in multiple areas of the web to see if data validation could be completed by using VBA code after the scan was entered and generate an error if it does not match something in a predefined list, but unable to find anything to accommodate. I have tried to place to code to clear the field before the error message is generated, but still get partial scans at times.
This does not have to be a data validation if I can have certainty that partial scans will not occur. I am open to alternate suggestions as well and I do appreciate any input provided.

Keebellah, Thank you for the response, I will work with this code and see what I can accomplish.

Hello Keebellah, Thank you for the information, I added code to my project and modified to suit.
I can get it to work, but when I save and re-open file, I am getting error from excel and have to recover file, but do not get everything back.
I changed the range to select only 10 cells for validation and everything worked fine. I can close and re-open with no issues.
When I increase the range to 20 cells, I get the error again.
When I try to upload copy of code, my server is blocking me due to content (security of our company does not allow code to be sent),
so I will send copy from home later.

Excel Error.PNG

Thank you also for the additional thread to see previous work of jorel (Lotomania),
however, there are four pages of posts and I couldn't determine which one it was.

I have attached a word document with the code as I keep getting blocked when trying to post code directly.

Hello Keebellah, The MsgBox was intentional so I could ensure that I had my files assigned correctly. When the line of code containing "MsgBox qRange" is removed, I am still getting the error after closing and re-opening the file. My codes is below.

Please Login or Register  to view this content.

I have gone through the code line by line, but to no avail for resolution.
I have attached a copy of the file (TPM Scans.xlsm) and with additional testing have determined that the line of code below:

Please Login or Register  to view this content.

needs the range to be set to ("A1:A210"), but when it is set to A1:A17 or greater is when I get the recovery error.
As long as it is set to A1:A16 or lower, no problems.
I have also played around with changing the file type from 2016 macro enabled workbook (xlsm) to 97-2003 workbook (xls) and it seems to be working fine.
There is another file attached (TPM TIR QR Codes.xlsx), which contains all of the QR codes used to scan data.
These QR codes match the data found on the third tab (TIRDescription) contained within the TPM Scans file.

I had also come to the conclusion that it has something to do with Data Validation.
I have looked at the updated information provided and do see that it will work, but there is still a concern.
Typically, this file would be open and running at all times, which would not be an issue.
My concern is that if we have a power outage or someone closes the file inadvertently, that the data would be lost.
The data for this sheet feeds into another workbook that is updated and broadcast on a television for a visual view of completed items.
We also need to ensure that there are no duplicate entries, and that code is no longer included in the file, but I can add it back.
Ultimately, at the end of the day, the data will be extracted into a MS Access Database to track historical data.
Not quite to that point yet, but it all ties together to a much more elaborate scheme than just this workbook.

I thank you very much for all of the assistance you have provided.
I would prefer to not include all files into a public forum, but if you were willing to look at them in a private manner, I'll be more than happy to share with you.
Please let me know if this is possible and how to go about doing and / or provide any additional input you may have.