Date in userform error message not working

Hi all,

I've got a userform which populates the next available row in an excel spreadsheet.

There are 2 boxes on my userform which require dates to be entered. Therefore I attempted to put them in as a date value and put an error message on when a date format is not used for entry. However the error code does not appear when the date is entered incorrectly, I just get asked to debug the code. It works fine when the date is entered correctly.

The code is below for the OK button (ie the populate the spreadsheet button). The Date box 1 is called txtDateToday and the Date box 2 is called txtDateExpected.

Please Login or Register  to view this content.

Hi,

Thanks for responding! That code works nicely, thank you