Entry into one cell clears other cells

[bkala]

I have a series of 10 cells, and I only want to be able to select one of the
cells. Therefore, if I put an "x" in one of the 10 cells, I want the cell
that currently has the "x" in it to clear out.
Thanks

 

[dlw]

are you trying to make a "radio button" type thing for data entry? If you do
a lot of that, this might help:

http://support.microsoft.com/kb/873209