Cell value

P

Pietro

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
 
B

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
 
M

Mike H

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
 
P

Pietro

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
 
Top