Prev: macro in excel
Next: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM
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
removed.
From: dan dungan on 18 Feb 2010 14:58
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.

Dan
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.
>
> Dan
> .
>
From: dan dungan on 18 Feb 2010 18:52
Hi Steve,

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*
,0x2A=R

=IF(F22="",R,0x2A)
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,
=IF(A1="",R*,R)

Dan
 |  Next  |  Last
Pages: 1 2
Prev: macro in excel
Next: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM