Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validating dates in a cell
I have a worksheet in which a transaction date is entered into cells
in column A. I need to validate that date when it is entered to insure it is no earlier than Today() and no greater than Today()+30. The worksheet is perpetual so data validation at the cell level won't work. How can I validate the date at a macro level so that the cell value doesn't become invalid 31 days in the future? TIA BrianG |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct - validating codes & dates | Excel Worksheet Functions | |||
Validating certain cell | Excel Worksheet Functions | |||
Validating Dates Entered | Excel Discussion (Misc queries) | |||
Validating Dates | Excel Programming | |||
Event validating two ranges with dates | Excel Programming |