Hi, i've got a small problem with a sheet which contains checkboxes.


The idea is to create a property sheet. in this sheet there are names in column A and checkboxes in column C

The script will be activated when a save button is clicked somewhere on the sheet. on that point i want the data to be collected

The most improtand thing is to collect the checkboxes in an array varaible
the dim will be this i think:
Please Login or Register  to view this content.
the issue is that the checkboxes are spread over the sheet.
they are centered at column C in every row from row 3.

the numerial must be from the most top row as first. and end up most bottom as the last (max 20 checkboxes)

Excample:
the Checkbox centered within: C3 = Chk(1)
C4 = Chk(2)
C5 = Chk(3)
C6 = Chk(4)
ect.


if the boxes are correct collected in the array decleared variable then i can make loops and collect these checkboxes for the other data that have to matter with it.

Thanks in advance