Clear cell contents when validation box is changed.

[bujaman]

Cell M11 has a validation list inside of it. I would like to clear the contents of cell M12 when the validation list in M11 is changed. Can this be done? Any help is greatly appreciated, thanks!

[Andrew-R]

Yes, you can do it using the SheetChange event.

If you open the VB Editor and double click on the ThisWorkbook item in the left hand pane, at the top of the code window there will be two drop-downs, select "Workbook" in the left-hand one and "SheetChange" in the right-hand one.

This will create an empy sub for you, which you can fill as below:

Please Login or Register  to view this content.