Each checkbox can be assigned to a "Linked Cell" (right-click the checkbox,
select Format Control, put the address into the Cell Link box
HTH
Bob
"Pietro" wrote in message
...
Hi all,

I have a check box on my excel sheet,i want that if i click on this check
box,the value of the cell beside becomes "true"
Example:
If i click on the checkbx located in the cell A1 then B1 =true else
B1=false
If i click on the checkbx located in the cell A2 then B2=true else
B2=false
If i click on the checkbx located in the cell A3 then B3 =true else
B3=false
If i click on the checkbx located in the cell A4 then B4 =true else
B4=false