checkbox / radiobutton

Hello,

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, is it possible?

Next, I tried using 2 checkboxes using the following code:

Checkbox 1:

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

Checkbox2:

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

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,

Sous2817,

There are a lot of responces to your cross post at
http://www.mrexcel.com/forum/showthread.php?t=305110


The link below this explains why posting a cross-link when cross-posting is required by the forum rules.