Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell value
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell value
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 "Pietro" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell value
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 "Mike H" wrote: 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 "Pietro" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
cell data not validated if navigating cell to cell with mouse | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |