Check Boxes

[MillerTime]

I need help,

I have multiple check boxes and i want the user to only be able to select one check box (when one is checked all others are unchecked). I also need a cell to hold a value based on which check box is checked.

Thank you

[ptm0412]

1. To force only one to be check: Surround all checkboxes with a Groupbox, a control found in tool bar Form.
2. To have the value based on which checkbox is checked:
- give the Property Linked cell of Each checkbox to a cell such as A1, then A2 for next one, ... (A1:A5 for 5 checkboxes)
- In B1: B1=Match(A1:A5,TRUE,0)

[MillerTime]

Thank you,

The second part works great but it still wont force only one box to be checked.

[Shijesh Kumar]

Why dont you try using Radio Button... by default when u select one other will be deselected.


-Click on View -> Toolbar ->form.
-From form toolbar select and create 4 to 5 radio button
-now right click any one radio button , select format control. Click on the last tab Control , U will see a filed called Cell link... Type eg. A1.

Now test your radio , you will see that when u select first radio button cell A1 show 1 when u select second radio button it show 2 and so on..

[MillerTime]

Excellent! Everything is working perfect, thanks for all the help.