Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation in Cell changes Range ID?
Hello,
I am assigning all my valid cells a Range ID by setting the Range Property "ID". If I add list validation to a cell and change its value using the validation drop-down, the cell looses its original ID and gets the ID of Cell which has the value. Why should both value and ID change for this cell (validated) when list validation is applied and not only value? Other properties like formats etc don't get copied over. Regds Gap |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation in Cell changes Range ID?
Hi Gap,
I replicate half your problem! If I set a DV list cell ID to some text, then change the cell value from the dropdown list, the ID is now totally empty. Ie nothing, not same as you - the new changed cell value. It does seem odd. Even if there is a fix bear in mind the cell ID is lost when you save close re-open the file. Regards, Peter T "Gap" wrote in message oups.com... Hello, I am assigning all my valid cells a Range ID by setting the Range Property "ID". If I add list validation to a cell and change its value using the validation drop-down, the cell looses its original ID and gets the ID of Cell which has the value. Why should both value and ID change for this cell (validated) when list validation is applied and not only value? Other properties like formats etc don't get copied over. Regds Gap |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation in Cell changes Range ID?
Hi Peter,
Yes, I am aware that ID's don't get persisted along with the file. ID will become empty if the source Cell has no ID assigned to it else it will get the ID of the Source Range even if its a string. If you Type in the value it behaves correctly. The moment you select from the drop-down it looses the original ID and gets the ID of the source cell.( Blank if it was'nt assigned one. Atleast thats what I see in Excel 2003) The behaviour is strange though, since the range object itself does not change. Its not consistent since only its "Value" property should change not others. Regds Gap |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation to range names for Chart Source Data | Charts and Charting in Excel | |||
How to optimize? large non-contig cell range for data validation l | Excel Discussion (Misc queries) | |||
Can the data validation list range of one cell be driven by theco | Excel Discussion (Misc queries) | |||
Data Validation and Name Range | Excel Worksheet Functions |