Thread: Problem: Yes/No check box in MS Excel

Kindly help me with the code for the following in MS Excel.

I have 2 check boxes (Yes & No) in a excel sheet.

This is my requirement

Intiallly both the check boxes are unchecked.

If I select Yes check box, it should be checked.
Now if I select No check box, No check box should be selected & Yes checked must be unchecked.
Now again if I select Yes check box, Yes check box should be selected & No checked must be unchecked.

When I check Yes check box, No should be unchecked.
When I check No check box, Yes should be unchecked.

@ rameshjee

the yes/no option you want to implement in your excel file, should be implemented with option buttons always. you will find option button tool just below the check box tool in the Froms toolbar. the default behaviour of option buttons is this - no, matter how many option buttons you have on your sheet, only one of them can be selected at a time. as soon as you select an option button all other option buttoons will get unchecked. check boxes are used when you need the user to select multiple options from a given list. i hope this helps you. i am a visual basic programmer (vba) and suggesting this to you as ms excel is also based on the same language(vba).

go to view on the menubar>toolbars>forms

the form toolbar should appear. it will look like this:



you can use yes/no option buttons like this:



as soon as you select the yes button, the no button will get unchecked and vice-versa.

this is the way to do it. option buttons are meant for this. if you still want the check boxes to behave your way, tell me, i will work that out for you.

Thanks saurav,I found the solution yesterday..Yup..we need to use the combo option.I would post it in a thread sometime this weekend.