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/
Bookmarks