ExcelBanter - Cell Value Override

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Value Override (https://www.excelbanter.com/excel-discussion-misc-queries/4420-cell-value-override.html)

saschamps9903

Cell Value Override

I would like to know if there is a way to change the value of a cell by
clicking on it. say for example, I have three boxes: one box has "Y",
another has "N" and yet another has "NA". the goal is to click on one of the
boxes and have the value replaced with an "X". Thanks.

All times are GMT +1. The time now is 05:06 AM.