Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If criteria not met then message box
I am very new to code. I have created macros in the past.
How can I write code that would let me manipulate data. For example: I want them to enter a date that automatically puts Sunday in the cel above it (Cell C5). I have this done in a formula so far!! What I want if it's not Sunday, is a message box that pops up and say "the date you entered is not equal to Sunday, change the date. " The go back to the cell so they can enter the new date? I am sure this is basic for some. I just can't get it to work -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Error Message as test Criteria | Excel Worksheet Functions | |||
Adding an error message at close of file when criteria are met | Excel Discussion (Misc queries) | |||
popup message if certain criteria met in formula result | Excel Worksheet Functions | |||
changing the message in an error message | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |