Excel - Yes No Checkbox

[AlreadyLost]

I have an excel sheet and currently the user can check both the No and Yes Check box. I want to disable one or the other if I check Yes then I should not be able to check no. Any ideas? Thanks

 

[jfhewitt]

AlreadyLost, the important thing is you don't need code. You can use a check box or option (radio) boxes, either Forms or Control Toolbox. If you want the user to indicate yes or no, a single check box will do it. If checked, the value in the linked cell is true, if unchecked, false. You can convert the true/false value to yes/no with an IF statement. If you want the user to affirmatively indicate "yes" or "no", the option box is the way to go. If grouped, only one option box will give a value. Option boxes are a bit more complex than check boxes, since Form option boxes return numerical values (1,2,3,etc) As previously suggested, if all you want is a yes or no in the linked cell, a single check box will do it. No code needed.