Hello,



I'm looking for a vba code where, if "Reclassifications", "Transfers", and "Change of pay rate" are selected in a dropdown, it goes back to the date field and verifies the date selected is a Monday (any Monday).

Reason being, that's the start of the pay period, and we're getting people choosing the date they're filling out the form, not a Monday. That Monday could be a week or two back, or a week or two in the future, so I just need it verify it's a Monday date.

If it's not a Monday, I'd like it to display a message that says, "Effective date must be a Monday (the first day of a pay period). Please enter the correct date."

Bonus points if we're able to then select the Effective date field / box so that when they hit "OK" on the error, the Calendar popout is displayed so they just pick the date.

I have attached a quick form for your use if it would be helpful.

Many thanks in advance for any help you can provide!!

Attached Files

Verify Date.docx (28.3 KB, 3 views)