I have used Data Validation to display a list of variables. I also have a secondary list whose content is based on the value selected in the first list. When I select a different value in List 1, List 2 is updated correctly, however, the cell displaying List 2 continues to display the old value. Is there a way to get the cell displaying the value from list 2 to either update or go blank when list 1 selection is changed?


Thanks

Hi AHB,

See the solution I posted at:
http://windowssecrets.com/forums/sho...474#post861474
The dependent selection is blanked via the macro code whenever the primary selection is changed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks Macropod. The macro works like a charm.
AHB