In my worksheet i have developed in a cell a drop down menu consisting of 3 choices through data validation. Depending upon the choice i would make in the drop down list, i have to enter input in the respective cell out of 3 cells reserved for input.

I would like to have a macro activate after i choose one among the drop down list and erase inputs if any, during my previous operations in the other two cells.

can any body help?