What I'm trying to do is have the userform I created do a date check to be sure that the new data entry is correct (ie advanced by one day). What I have come up with so far is to have the date from the previous row of data show on the userform and have vba check that this date is 1 day prior to the new date being added to the spreadsheet. What I haven't figured out is (1) how to have it reference the date in the prior row (and make this value be uneditable by the end user) and (2) possibly the date check itself (I need to get the first completed to see if the second works). As always, all help is greatly appreciated.

CheckDate.xlsm