| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check boxes
I've added check boxes next to cells in a database. I want to sort by those
which are checked and which are not. How do I link the checkbox to the cell it corresponds with? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
hi
assign the linked cell property of the check box to the desired cell. needs to be a blank cell becasue the linked cell will display true for check and false for not checked. sort by the linked cell. regards FSt1 "caroly" wrote: I've added check boxes next to cells in a database. I want to sort by those which are checked and which are not. How do I link the checkbox to the cell it corresponds with? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Check boxes
If you link the check box to the cell it hovers over than set the font color
of that cell to white, the "True" or "False" will not be visable and with the box over the linked cell it helps to protect it from accidental over write. You may need to adjust the size of the box. "FSt1" wrote: hi assign the linked cell property of the check box to the desired cell. needs to be a blank cell becasue the linked cell will display true for check and false for not checked. sort by the linked cell. regards FSt1 "caroly" wrote: I've added check boxes next to cells in a database. I want to sort by those which are checked and which are not. How do I link the checkbox to the cell it corresponds with? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check boxes | Excel Discussion (Misc queries) | |||
| Check Boxes | Excel Discussion (Misc queries) | |||
| How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Linear Mode
