Should I use a radio button or checkbox?

[sous2817]

Hello, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I'm making a worksheet where the user has the options to select "yes" or "no". I used active x radio buttons because I feel they are more flexible. The problem I'm running in to is, what happens if there is an "unknown"? I can't find a way to "deselect" a radio button?<o></o>
<o></o>
I tried using 2 checkboxes using the following code:
<o></o>
Checkbox 1:

If CheckBox2.Value = True Then
CheckBox1.Value = False
End If 

<o></o>
Checkbox2:

If CheckBox1.Value = True Then
CheckBox2.Value = False
End If

<o></o>
The problem with this is, you have to deselect one checkbox before you can select the other. It works, but it’s a little more cumbersome then I was hoping. Is there a better solution?

Thanks for your time,<o></o>

 

[sous2817]

You can't deselect and options button. I could make it work adding a third options button, but I'm kind of designed myself in to a corner in terms of space.

If I can be greedy, the best solution would be a way to add code in that makes it so an options button could be deselected once it is selected (click once to flag True, click againt to flag False). I think this is a limitation of an options button isn't it?

 

[Jonmo1]

yep..

 

[sous2817]

Oh well, that's too bad...you can make a check box act like a radio button but not the other way around, weird.

At the very least, my problem is solved and I can't thank you enough....Have a great weekend!