From: SteveF on 18 Feb 2010 14:34
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
From: dan dungan on 18 Feb 2010 14:58
I'm not sure which Excel version you're using, but when I try adding
checkboxes to a spreadsheet with Excel 2000, the workbook starts to
crash unexpectedly to more objects I add.
Your situation sounds like a job for a userform.
From: SteveF on 18 Feb 2010 17:49
Update: sorry I'm using 2003. I've never done any logic statements but I was
hoping it would be easy and look something like this (I know these are not
the right symbols): (IF A1,("") then (ü) IF A1,(ü) then (""))
Maybe I'm just being stupid :)
"dan dungan" wrote:
> Hi Steve,
> I'm not sure which Excel version you're using, but when I try adding
> checkboxes to a spreadsheet with Excel 2000, the workbook starts to
> crash unexpectedly to more objects I add.
> Your situation sounds like a job for a userform.
From: dan dungan on 18 Feb 2010 18:52
You could use the check box from the character map.
I found the characters in the Wingdings font.
I needed to change the font for the column containing the formula. So
you could do this with conditional formatting.
0x52 = R*
From: dan dungan on 18 Feb 2010 19:01
I accidentally sent the previous message before I was finished.
What I meant was:
In excel 2000 on my computer, the wingdings 2 font has Character code
0x52 which shows R until you change the font to wingdings2. Then you
see the check mark in a box.
Character code 0x2A shows R* which is an empty box.
So if you are evaluating A1 the formula,