Change Date with Date Picker If Date Less Than 7 Days From Another Date

I have a userform with 2 date pickers, The below code activates a message box if the date in dTpicker2 is greater than 6 days from DTpicker1, this works fine.

I cannot get this macro to change the date via DTpicker 2 if the date is less than the 6 days, what do I have to add to make this happen, at the moment it will not change any date on sheet1 that is less than the 7 days.

Please Login or Register  to view this content.

Thank for any assistance

Hi there,

I may have misunderstood your requirements, but see if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Thanks Greg M that works perfect, I will mark as solved.

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M