Hi Dave, Thanks for the help. I got it to work but I had to increase the
height of the cell in order to get it to work. I would like to have the
standard row height. Did you get it to work with standard row height?

Thanks
Quinton

"Dave Peterson" wrote:

If you're very careful when you put the checkboxes in the cells (make them fit
totally within the row--no overlapping of multiple rows), they should sort ok.

And make sure you haven't changed this setting:
rightclick on each checkbox
format control|properties tab|make sure "move but don't size with cells" is
checked.

(It was the default in my tests.)



Q wrote:

Hi all,
I am inserting employee time into Excel, and I would like to be able to sort
the columns by "Recorded", "Date", "Customer", or by "Employee". For the
Recorded column I am using a "Forms check box". The problem is can't seem to
get the check boxes to sort with its corresponding rows.

Here is my layout

Recorded Date Customer Employee Description
(Check box) 10-1-05 John Doe Tom Comments
(Check box) 10-1-05 John Doe Harry Comments
(Check box) 10-2-05 Jane Doe Dave Comments
(Check box) 10-3-05 John Doe#2 Jim Comments
(Check box) 10-4-05 John Doe#2 Jim Comments
(Check box) 10-6-05 John Doe Tom Comments

Can someone help me out with this?

Thanks
Quinton

--

Dave Peterson