Check box - recognise if it is checked or not?

[Fireman_Simon]

Hi Everyone!
Please help my "bitten-of more than I can chew project".
I have two columns next to one-another with check-boxes in them. One column for YES, and one for NO. What formula do I need for the recognition of the box being checked or not? Also, as the option is YES or NO, can I include something to prevent both check boxes in the same row being ticked OR not ticked?
Advice greatly appreciated.

Many thanks, Simon.

 

[Corticus]

Hi,

First, to get value from checkbox, right-click on the checkbox, select properties, and put a cell reference in 'linked cell'. You will refer to this cell to test the status of the checkbox.

To prevent both yes and no from being clicked, try:

I'm using these names:
Yes = Checkbox1
No = Checkbox2

Now insert the following code on the sheet:

Private Sub CheckBox1_Change()

CheckBox2 = CheckBox1 + 1

End Sub

Private Sub CheckBox2_Change()

CheckBox1 = CheckBox2 + 1

End Sub

HTH,
Corticus