Hello again,
My userform is coming along pretty well. I have figured out a way to date and time stamp the data that is being entered and a preliminary duplicate entry prevention code. I am learning as I go and I really appreciate all of the help!
I have a attached the workbook.
There are three things that I am wondering about:
1. When entering the numbers into the userform the date/time fills the textbox next to the entered barcode, can someone help with code to have the time/date disappear if the barcode is cleared from the textbox
2. The piece of code I have to prevent duplicates only works if the barcode has been entered into the spreadsheet, can someone help with code to have the duplicate prevention also check that there are no duplicates in the textboxes before transferred to the spreadsheet
3. The piece of code I have to prevent duplicates only works if the barcode has at least one alpha character, can someone help with code to have the duplicate prevention check barcodes regardless if letters or numbers are used
Thank you for the support I am sure others will find this useful barcodetest.xlsm
Bookmarks