Hi- I searched the forums for this information, but couldn't find my answer. some were close, but not really what i needed. If there is a thread to answer my question, please reply with it. If not:
In cell A1, B1 and C1 I have 3 data validation lists. A1 being Month (displayed as Month name rather than number e.g. "Jan", "Feb", "March", etc). B1 being the day #, and C1 being the year.
In cell D1 I have the following formula, which takes the entry from those cells and puts it in mm/dd/yyyy format:
=(MONTH(DATEVALUE(A1&" 1")))&"/"&B1&"/"&C1
In cell E1, thanks to users on this forum, I have the following formula which validates the date to make sure its a real date, and if not the formula says "Invalid date":
=IFERROR(DATEVALUE(D1),"Invalid date")
At the bottom of the sheet, I've created a macro button that will prompt the user for more information. However, before it prompts the user for more information i need the macro to validate the date entered above.
If the user entered an invalid date, i need the macro to prompt the user to fix the date and then exit the macro.
If the user entered a valid date, i need to macro to go to next.
Am i making this too complicated? If you have any better ideas please share, i'd be interested to see your logic.
Bookmarks