Linking multiple check boxes to multiple cells

Question

I am trying to figure out how to link multiple checkboxes individually to multiple cells without having to do each step over and over. I have over 3000 cells that need check boxes linked. I thought that copying and pasting would suffice, but it copies the exact cell link which is not what I need. Is there a way to do that easily? I don't have the time to individually set the cell link for each of 3000 cells.

Answer 1

Were you able to download it?

Hi,

Eventually, I just got it and I think your going about this in fundamentally the wrong way.

IMHO I think having what could end up as; literally, thousands of checkboxes and linking them to thousands of cells is a nightmare so instead of

=COUNTIF(E2:DL2, TRUE)

I would use

=COUNTA(E2:DL2)

Then instead of checkboxes you would simply enter a character of your choice to indicate attendance and the formula would count delegates.

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 2

Here's the link http://rapidshare.com/files/432732835/Training_Tracker_Temp_-_HELP.xlsx

I added a comment to one of the cells in the spreadsheet with my explanation of what I need help with. Thanks!

Answer 3

I am not familiar enough with Macro to use this without more info. I have the spreadsheet if I could email it.

Hi,

You can upload the file here and post the link, it's free.

 If you clearly describe on a seperate sheet in the workbook exactly what you want doing then I'll take a look.

http://rapidshare.com/

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 4

I am not familiar enough with Macro to use this without more info. I have the spreadsheet if I could email it.

Answer 5

Assuming that the linked cells are grouped together, you could use this short marco

Sub LinkChecks()

'Starting row

i = 4

For Each cb In ActiveSheet.CheckBoxes

cb.LinkedCell = Cells(i, "A").Address

i = i + 1

Next cb

End Sub