Excel Sheet and Radio Buttons

[nanders8]

I have an excel sheet that we are using for call monitoring. I have a Yes column, a No column, and a N/A column and rows that have different criteria. What I am wanting to do is somehow create either a formula or a macro where all of the cells under column Yes have an X in them automatically, then when someone clicks on the cell either in column No or column N/A, it places an X and removes the X from the Yes column.

Is this possible?

I was trying to use Radio buttons to accomplish this but have not found an easy way to create multiple radio buttons that are not linked together.

Any assistance would be great!

Thanks!

 

[Oaktree]

Radio buttons are the easiest way.

If you're using the ones from forms controls, you need to put a group box around the ones you want grouped together.

If you're using the ones from ActiveX, they're grouped according to the GroupName property (in design mode, right click on a radio control, go to properties, and edit the GroupName accordingly for your groups)