VBA Code Required (Date Entry Restriction)

[abid.aries]

Dear Valued Experts,

I am in search of a vba code that can restrict date entry in my excel sheet.

Restrict date entry means user can not enter a date which is more than 4 days old.

Thanks in advance.

 

[Nebu]

Hi:

You can use data validation to you achieve this

Step1:
Give a formula in a cell= Today()-4
Step 2:
Use the following setting in data validation(here I have given the formula in Cell A1)


Step 3:
Apply this validation to whichever cell you this rule to apply.

Thanks

 

[abid.aries]

Thanks Bro it worked