Hello, I want to use Date Picker falong with Date Validation feature. Currently Date validation does not work if i insert date using Date Picker.
Can you help please?
Validation only works on data entered from the user interface whereas you are entering data from VBA. You cannot prevent inappropriate dates from being entered but you can test them with a formula and flag them as errors.
Alternatively, since entering a date from VBA will trigger a worksheet change event, you could test the date and clear any erroneous values using code.
