Cell value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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
 
Back
Top