Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box (Form Control)
In Excel 2007, I want to put in a check box that will be in sync with date
information on the spreadsheet. For example, column A has the check box, column B - item description, column C - date. If I wanted to sort my spreadsheet by date, let's say, how do I get the checked (or unchecked) box to move with that data sort? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Box (Form Control)
There are 2 aspects to making this happen. In the properties of the control
when you right click and select format control ensure that the option button Move but Don't Size with Cells is selected. The other requirements is that the check box must reside entirely in one cell. So column A cells must be large enough to entirely fit the check box within it's borders. -- HTH... Jim Thomlinson "Liz J" wrote: In Excel 2007, I want to put in a check box that will be in sync with date information on the spreadsheet. For example, column A has the check box, column B - item description, column C - date. If I wanted to sort my spreadsheet by date, let's say, how do I get the checked (or unchecked) box to move with that data sort? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control on Form | Excel Discussion (Misc queries) | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
How can i change the size of a form control check box? | Excel Discussion (Misc queries) | |||
How do I add a control check box to control other checkboxes? | Excel Worksheet Functions | |||
form control - check box | New Users to Excel |