Re: Filtering by Check Boxes

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.


Eggtavius wrote:
>
> I have created a multi*** 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.
> --
> Many Thanks
> EGGcel

--

Dave Peterson
.

Quantcast