View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ZipCurs ZipCurs is offline
external usenet poster
 
Posts: 103
Default 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