Filtering by Check Boxes

[Guest]

I have created a multisheet workbook for my staff.

One of the pages summarises results from the other worksheets.

On this summary page, I have used check boxes in one of the columns to allow
users to select relevant records and then filter for those records to show
only those where the check boxes are True.

Am experiencing problems with:

1. After filtering, some of the check boxes that were previously checked are
no longer checked.

2. Removing the filter and reapplying the filter returns different records.

Any ideas would be appreciated.

 

[Dave Peterson]

Did you use checkboxes from the Forms toolbar or from the Control toolbox
toolbar?

If you used the Forms toolbar version, then maybe you're looking at the wrong
checkbox. Hiding the rows doesn't hide the checkbox.

If you used the control toolbox toolbar, make sure that you chose "Move and size
with cells" (after rightclicking on it and choosing format control|properties
tab).

=======

You may want to take a different approach.

If you delete all the checkboxes, maybe you could just format the cell nicely.

Select the range
Format|cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Hit the delete key on the keyboard to clear the cell.

If you have to use that "checkmark" in later formulas:

=if(a1="","no checkmark","Yes checkmark")

And since this is just data, it'll sort (well, if you include that column in the
range).

And you can always filter for that funny character.

 

[Guest]

I had originally experimented with both Control and Form Check Boxes and had
tried various properties and format settings without success.

I have decided to use the alternative solution that you have suggested
instead of the check boxes - less risk of things going wrong. Much
appreciated!!
--
Many Thanks
EGGcel

Did you use checkboxes from the Forms toolbar or from the Control toolbox
toolbar?

If you used the Forms toolbar version, then maybe you're looking at the wrong
checkbox. Hiding the rows doesn't hide the checkbox.

If you used the control toolbox toolbar, make sure that you chose "Move and size
with cells" (after rightclicking on it and choosing format control|properties
tab).

=======

You may want to take a different approach.

If you delete all the checkboxes, maybe you could just format the cell nicely.

Select the range
Format|cells|number tab|custom category
In the "type:" box, put this:
alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
mark.

Hit the delete key on the keyboard to clear the cell.

If you have to use that "checkmark" in later formulas:

=if(a1="","no checkmark","Yes checkmark")

And since this is just data, it'll sort (well, if you include that column in the
range).

And you can always filter for that funny character.