Cell value

[Guest]

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

 

[Bob Umlas]

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

 

[Guest]

Hi,

Right cleck the checkbox format control and type the address of your
attached cell in.

The attached cell will switch between true/false as the box is
checked/unchecked.

Mike

 

[Guest]

Thank you Mike for your answer,
I couldn't understand this "type the address of your attached cell in."
I could not understand also where exactly shoul i input this address