Macro Linking Checkboxes to Cells with Relative References instead of Absolute

Hello all,

I am just learning VBA code and I came across the following macro:

Please Login or Register  to view this content.

It is pretty neat--It adds a checkbox (of the "forms toolbar" type) and links it to each cell that has been selected. The check boxes when clicked turn their linked cells yellow. It really increases user-friendliness.

The only complaint I have is that the checkboxes end up being linked to absolute cell references. I want to be able to sort and filter my data and keep the checkboxes with their rows even when I move them around.

Is there any way to do this? I was hoping someone could very quickly modify the above code to produce this result.

I am also open to any other easier method that someone could suggest.

Thanks in advance,
Nick

Hello Nick,

All Worksheet controls, whether Forms or Control Toolbox types, are drawn on the worksheet, and linked to a cell by the Upper Left Corner of the control which intersects with it. This is how Excel knows where the control is. Unfortunately, these controls aren't shifted when a Range they are attached to is sorted. To do what you want would require writing a specialized sort macro in VBA.

Sincerely,
Leith Ross