Validation Not Triggering

Question

I have a date field with Validation set to dates between with a date picker UserForm.

When I select the date from the date picker and populate the cell it does not trigger the validation check.

I have unchecked the Ignore Blanks on the validation settings but it is still not triggering?

Help would be appreciated.

Answer 1

Unfortunately Data Validation does not work if the value is inserted with VBA code. The validation only works if the User inserts the required value in the interactive mode on the worksheet.

Also if you copy a value and paste the value into the Data Validation cell then the validation does not work. 

Plus if a cell is copied and pasted (ie. standard paste) then the Data Validation is actually over written and gone altogether.

You will need to include some VBA code in an If statement to perform the validation immediately prior to the code that inserts the value. Since you are using VBA code for the process then I assume you will know how to insert the If statement to validate. However, if you need more assistance with this then please post the section of code that writes the value to the worksheet and I will assist further.

Answer 2

Good idea I will try that thank you.