Verify date based on dropdown selection
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!!
|