Hi all,

I have created a couple of conditional drop down lists (via data validation), and wanted to know if I can reset a cell when the value of a list is changed.

EG:
Cell A1 and B1 have list boxes. The options in B1 are dependent on the selected option in A1. This works great.
What I want is that if I have selected option from A1 and B1, then change A1, cell B1 should requery or set to null.

Is this possible?

Thanks for any assistance