software

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.
--
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 quot;Move and size
with cellsquot; (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 quot;type:quot; 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 quot;checkmarkquot; in later formulas:

=if(a1=quot;quot;,quot;no checkmarkquot;,quot;Yes checkmarkquot;)

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:
gt;
gt; I have created a multisheet workbook for my staff.
gt;
gt; One of the pages summarises results from the other worksheets.
gt;
gt; On this summary page, I have used check boxes in one of the columns to allow
gt; users to select relevant records and then filter for those records to show
gt; only those where the check boxes are True.
gt;
gt; Am experiencing problems with:
gt;
gt; 1. After filtering, some of the check boxes that were previously checked are
gt; no longer checked.
gt;
gt; 2. Removing the filter and reapplying the filter returns different records.
gt;
gt; Any ideas would be appreciated.
gt; --
gt; Many Thanks
gt; EGGcel

--

Dave Peterson

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
EGGcelquot;Dave Petersonquot; wrote:

gt; Did you use checkboxes from the Forms toolbar or from the Control toolbox
gt; toolbar?
gt;
gt; If you used the Forms toolbar version, then maybe you're looking at the wrong
gt; checkbox. Hiding the rows doesn't hide the checkbox.
gt;
gt; If you used the control toolbox toolbar, make sure that you chose quot;Move and size
gt; with cellsquot; (after rightclicking on it and choosing format control|properties
gt; tab).
gt;
gt; =======
gt;
gt; You may want to take a different approach.
gt;
gt; If you delete all the checkboxes, maybe you could just format the cell nicely.
gt;
gt; Select the range
gt; Format|cells|number tab|custom category
gt; In the quot;type:quot; box, put this:
gt; alt-0252;alt-0252;alt-0252;alt-0252
gt;
gt; But hit and hold the alt key while you're typing the 0252 from the numeric
gt; keypad.
gt;
gt; It should look something like this when you're done.
gt; ü;ü;ü;ü
gt; (umlaut over the lower case u separated by semicolons)
gt;
gt; And format that range of cells as Wingdings.
gt;
gt; Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check
gt; mark.
gt;
gt; Hit the delete key on the keyboard to clear the cell.
gt;
gt; If you have to use that quot;checkmarkquot; in later formulas:
gt;
gt; =if(a1=quot;quot;,quot;no checkmarkquot;,quot;Yes checkmarkquot;)
gt;
gt; And since this is just data, it'll sort (well, if you include that column in the
gt; range).
gt;
gt; And you can always filter for that funny character.
gt;
gt;
gt; Eggtavius wrote:
gt; gt;
gt; gt; I have created a multisheet workbook for my staff.
gt; gt;
gt; gt; One of the pages summarises results from the other worksheets.
gt; gt;
gt; gt; On this summary page, I have used check boxes in one of the columns to allow
gt; gt; users to select relevant records and then filter for those records to show
gt; gt; only those where the check boxes are True.
gt; gt;
gt; gt; Am experiencing problems with:
gt; gt;
gt; gt; 1. After filtering, some of the check boxes that were previously checked are
gt; gt; no longer checked.
gt; gt;
gt; gt; 2. Removing the filter and reapplying the filter returns different records.
gt; gt;
gt; gt; Any ideas would be appreciated.
gt; gt; --
gt; gt; Many Thanks
gt; gt; EGGcel
gt;
gt; --
gt;
gt; Dave Peterson
gt;