Check to ensure that two dates are within one year

Hello All

Very new in VBA so please do excuse if i sound illogical, i am building a excel sheet which has inputs in form of dates in two cell i have used a date picker for that.
After getting the dates in the cells i need to check if the start and the end date should not exceed one year.

In case it does then it should pop a message stating that it has exceeded a year and then wipe out the two dates if they are within a year they should remain as is.

Looking for all the help and thanks in Advance

Laid out in simple code for you

Please Login or Register  to view this content.

Hello All

Thanks both for the suggestions, however i think that the change event code method would be the right approach, however i am facing a problem when i insert a date picker in that, i am attaching the sheet that you send sktneer with the object inserted. also i couldn't figure how to customize the cells, the cells in my sheet are C14 and E14.

Thanks again for all your help

Regards
Ajil

Hello sktneer

Thanks for your post, i have been able to utilize the code successfully in the sheet and its working if i am inputting the dates, however in order to standardize i am trying to use a date picker module but the code does not seem to work. Could you please help further ?