Unticking Checkboxes with VBA based on row

Originally Posted by Darkcloud617

However, when it deletes the cell with the checkbox it causes it to overlap with the checkbox above it.

that's because excel automatically resizes its interface when a piece of the grid is removed, and the objects on top of the grid slide along with it.

to untick a box, you can reference it in the controls collection, and the type it is, for instance:

dim c as control
   for each in c in controls
      if typeof c = accheckbox then
         'if you've found the name of the control, untick it here (c.value = 0
      end if
   next c

I don't think there's anyway you can identify a box by the row number that it sits on top of because it is technically not part of the grid. a row is part of the grid.