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

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

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