Incorporate Data Validation in Macro to enter Date

I have the following code below , which allow the user to enter a date in A3 on sheet "WML"


I have set up data validation to only accept dates from Aug 2020 to Dec 2099


However, when using the Macro to input the Data, it accepts any data

The data validation to be incorporated into the macro must force the user to enter a valid month and year eg Aug 2020, July 2020

Months such as Aug 20050 , July 20201 should not be accepted

It would be appreciated if someone could assist me


I have attached sample data


Have posted a similar question on link below



https://www.mrexcel.com/board/thread...-year.1146483/

Please Login or Register  to view this content.