clara,
No, there's not a 'linked cell' like there would be for a dropdown list from
one of the toolboxes.

"clara" wrote:

Hi JLatham,

Thank you very much. I alway think there is a hidden reference between the
displayed cell and the validation list, but It seems not. So, there is no
hack way to do the change. Anyway, thank you very much for your code.

Clara
--
thank you so much for your help


"JLatham" wrote:

clara,
See my other post for detecting a change in the actual list used for
validation - it's looking for changes in that list, be they additions or
deletes or just changes.

The problem is really to update the displayed selection over in the
validated cell, which after some thought, is what I think you're actually
after. Is it?

If that's the case then we have to add some more code to basically compare
each entry in the validated cells with all entries in the (changed) list and
if the entry in the validated cell(s) doesn't match any entry in the list,
then make an assumption that the value it shows was the one that was changed
and force it to the new entry.

Example: your list contained an item "Joan" and one or more of the
validated cells had that choice chosen, so those show "Joan" in them. Now
you go to your source list and change "Joan" to "Joanne" but the validated
cell still shows "Joan" - since we don't know that "Joanne" was "Joan" before
the change, we have to look at all validated cells, get their value and
compare to all values in the source list, and if it doesn't match (we don't
find "Joan" in the list) we make an assumption that Joan used to be in the
source list and it was changed to Joanne (detected by _Change event) and
change "Joan" to "Joanne" over in the validated cell.

Is that what you're looking for?

"clara" wrote:

HI Bob,

How can I trap the list change event, could you give me some clues?

Clara
--
thank you so much for your help


"Bob Phillips" wrote:

Not directly as it reflects a selected value, not a reference to a list
position. I think that you would have to write some VBA to trap the list
change and update the DV knowing what it was and where that was in the
original list.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"clara" wrote in message
...
Hi all,

I have changed the list of a data validation, how can I make the
corresponding data validated field refreshed.

Clara
--
thank you so much for your help