Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a checkbox be created with a logic function?
I currently have a SS that utilizes a column of checkboxes. I also have a
macro that filters for checkboxes that are TRUE, thus hiding the rows with unchecked boxes. The two things I don't like with this configuration are that the checkboxes are too small, and when I filter, many of the unchecked checkboxes superimpose themselves on what becomes visible on the SS. So my question is: can a logic function be written so that if an open cell is selected, it is automatically populated with a text checkmark? And secondly, if a cell with that checkmark is selected again, the checkmark is removed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you assess the state of a form-checkbox in a logic statemen | Excel Worksheet Functions | |||
IF/OR Logic Function | Excel Worksheet Functions | |||
Logic function for between | Excel Discussion (Misc queries) | |||
Can't Trigger Event Procedure from a Checkbox created on the Fly. | Excel Programming | |||
Logic Function Help… | Excel Discussion (Misc queries) |