VBA DATE format check in xlsM

perform those checks and pop up a message to the user based on value of Cel D6 Case 1 Day must be 16 or 1 for example 04/01/2015 is not valid must be either 16/01/2015 or 1/02/2015 Pop up Message: Start Day must be 1 or 16 of the month! Case2 Date value from cel D6 must be at least 2 weeks before todays date Pop up Message: Your request must be sent 2 weeks before start date! Case3 D6 cannot be null Pop up Message : You must insert a start date! Case4 D6 date format must be dd/mm/yyyy like 16/01/2015 Pop up Message : Date format must be dd/mm/yyyy! Every time D6 value WRONG and don’t pass the checks cursor goes back to cell D6 and D6 is clear If D6 value is correct then user can do whatever. There are 2 options that you can use: That can be done when a button is pressed OR on lost focus or after update one or the other is good. I would prefer a lost focus or after update Give back a xlsm