P
professorplum101
Does anyone know what event is associated with a change in a
validation list box? I have a row of about 20 "parent" validation
list boxes and two rows of about 20 "child" validation list boxes
(whose criteria change based upon the parent's). These cells
automatically set themselves to certain values, but the user needs to
be able to adjust them. I am trying to determine how to at least
blank out the child lists if the parent associated with it is changed.
For instance, If one box lists states and another lists cities, and
California is in the parent box and Los Angeles is in the child, how
do i keep the child from staying on Los Angeles when the parent is
changed to Oklahoma? This is a rather critical operation in my
code.
Thanks for your help!
Brian
validation list box? I have a row of about 20 "parent" validation
list boxes and two rows of about 20 "child" validation list boxes
(whose criteria change based upon the parent's). These cells
automatically set themselves to certain values, but the user needs to
be able to adjust them. I am trying to determine how to at least
blank out the child lists if the parent associated with it is changed.
For instance, If one box lists states and another lists cities, and
California is in the parent box and Los Angeles is in the child, how
do i keep the child from staying on Los Angeles when the parent is
changed to Oklahoma? This is a rather critical operation in my
code.
Thanks for your help!
Brian