I have used Data....Validation to create 2 dropdown boxes in adjacent cells (repeated about 50x down the page). The second drop down (col c) is dependant on the selection in the first cell (col b), which I achieved by using the indirect function in the source input (figured that out by reading board archive...Thanks, great tool).
My problem arises when a the user changes, or deletes the first cell. The old value remains in the second drop down.
How can I get the second cell to erase when the first is changed?
Is there an event trigger in VBA, that says if any cell in a row changes, then delete the cell 1 row to the right?
My problem arises when a the user changes, or deletes the first cell. The old value remains in the second drop down.
How can I get the second cell to erase when the first is changed?
Is there an event trigger in VBA, that says if any cell in a row changes, then delete the cell 1 row to the right?