Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Data Validation work on cells with formulas?
I've tried to put data validation on a cell that gets its value from another
cell, in another worksheet. When the value changes, data validation does'n kick in. How come? This is my example: cell A1 in sheet2 is equal to B2 in sheet1, I put data validation on cell A1 in sheet2. When the value in B2 sheet1 changes, it also changes in A1 sheet2 but the my validation is not followed and no pop up box appears. Any info would be helpful, thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Data Validation work on cells with formulas?
From "Help" on Data Validation ....
Messages appear only when data is typed directly into the cells. Your message won't appear: When a user enters data in the cell by copying or filling. When a formula in the cell calculates a result that isn't valid. When a macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.) enters invalid data in the cell. "Ruben" wrote: I've tried to put data validation on a cell that gets its value from another cell, in another worksheet. When the value changes, data validation does'n kick in. How come? This is my example: cell A1 in sheet2 is equal to B2 in sheet1, I put data validation on cell A1 in sheet2. When the value in B2 sheet1 changes, it also changes in A1 sheet2 but the my validation is not followed and no pop up box appears. Any info would be helpful, thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom data validation doesn't work well | Excel Worksheet Functions | |||
Data validation don't work | Excel Discussion (Misc queries) | |||
Why does data validation not work when pasting data into a cell. | Excel Discussion (Misc queries) | |||
Data Validation Error Does Not Work? | Excel Worksheet Functions | |||
Data Validation doesn't work on 1 sheet only | Excel Discussion (Misc queries) |