Hi everyone, I apologise for being noob, I'm new to posting on this forum (even though I've been a member for ages!)

I'm having difficulty with validation (not my own btw... Excel's) validation works fine when you enter text into a cell, but it doesn't work when you are working with a user form.

I have a user form that includes the date picker, the user selects the required date and that date is copied back to a cell. The problem is that the validation does not pick up an invalid date using this process.

Unfortunately I can't seem to attach the spreadsheet for you to see it.

Untitled.png