Sorting Check Boxes
I have a worksheet with data that I build and sort with macros to present the
data in different desirable fashion. Each line of the data has a check box
to allow a flag to be set by the user. Although the check box moves with the
data, the linked cell stays constant. As such, I need to delete all of the
check boxes, sort the data, and then recreate the check boxes. This works
but is a little time consuming. Is there a way to have the linked cell move
with the check box? For what it is worth, the cell is directly under the
check box.
Thanks
|