Hi- I wrote a macro, and need help with making a prompt. I need to do the following:
1. Prompt the user to enter a date in mm/dd/yyyy format... this date also needs to be a Saturday
2. If they enter the correct information, I want to continue the rest of the macro
3. if the user enters anything other than a Saturday date in the correct format, i need a loop prompt telling them to re-enter the correct information. I need this message to come up until they enter the correct information
3a. if they click cancel, I need to stop/exit the macro
Any help would be great. I cannot seem to figure out the loop or the If statements.
Bookmarks