Auto-check checkboxes based on cell value

[Rocky2013]

Hello,
Need some help on the checkboxes.

Has three checked boxes. Box 1 , 2, 3

If A1 = "Yes", Checkbox 1 will be checked.
If A1 = "No", Check box 2 will ne checked.
If A1 = 3, Check box 3 will be checked.


Thanks

[6StringJazzer]

Link each checkbox to a different cell. In the cells corresponding to those checkboxes put the following formulas:

Checkbox 1: =A1="Yes"
Checkbox 2: =A1="No"
Checkbox 3: =A1=3

The way you link the checkboxes depends on whether they are ActiveX or Forms. For ActiveX, go to Design Mode, right click on the checkbox, and in Properties, fill in LinkedCell with the cell address. For Forms, right click, select Format Control, select the Control tab, and use the "Cell link" box to select a cell.

[Rocky2013]

Hello,
Thanks very much for the help; it works without use of VBA.

I learn something new today, I did not know it is possible.
I use form control.

Thanks

[6StringJazzer]

By the way you can put the checkboxes right on top of the linked cells to hide those formulas.

[Rocky2013]

OK. I already use your help for my excel file already. This eliminates to manually checking the box.

Thanks