Thread: Cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pietro Pietro is offline
external usenet poster
 
Posts: 62
Default Cell value

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