Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Behavior
Excel XP, Win XP
Scenario 1: Cell A1 is not a Data Validation cell. Cell C1 is a Data Validation cell, with a list of dates of one month. Enter a date in A1. A Worksheet _Change macro fires and enters a date 7 days less than A1 into C1. The Data Validation in C1 defaults to that date (7 days less than A1). Scenario 2: Same scenario except that A1 is a Data Validation cell as well as C1 with the same list. Select a date in A1. The Change macro fires. Nothing is entered into C1. C1 Data Validation does not default the A1-7 Why? I know that I can write code to change the list for C1 to start at 7 days less that A1. But why doesn't the default thing work? Thanks for your time? Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
custom data validation on cells with data validation values | Excel Worksheet Functions | |||
Link behavior with changing data set | Excel Discussion (Misc queries) | |||
pivot w/ a different workbook as data source - odd behavior | Excel Discussion (Misc queries) | |||
Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
question data validation and delete/clear behavior | Excel Programming |