[MacShand]

Hi there

This is going to be quite long winded so apologies in advance.

I have a worksheet in excel working brilliantly with all kinds of codes written in and everything's ok...apart from one thing

I have a column with check boxes in them. When checked, they apply formatting to a cell in the same row. So, Check Box 35 when checked, turns A35 Green and C35 Green.

However, if I need to move rows, the check boxes still correspond to their pre-set row.

i.e. If i move Row 35 (including Check Box 35) to become Row 4, Check Box 35 still applies to A35 and C35 which no longer makes sense.

I'd like the check box to apply to the row it's in regardless of where I move it to.

Hope that makes sense and suggestions would be brilliant!

Thanks

M

[redoak]

If help doesn't appear, click "Report" in the lower right and ask that your Thread be transfered to the "Business Applications" Forum.

{redoak}

[wedonttakecrap]

I'd recommend using the Indirect() function and making your cell references using R1C1 style.

for example if I wanted to make a formula to sum cells in the next four columns in the same row, my formula would be : =SUM(INDIRECT("c[1]:c[4]",FALSE))

That formula would work no matter where you move it to. It's useful especially in workbooks where rows and columns are moved or deleted frequently.

More detail as to which version of Excel you are using and if your check box is a form control or ActiveX control, and I could elaborate a little more. My preference is to Form Controls to avoid slowdowns with VBA.

happy hacking!