Forms or controltoolbox checkboxes ?

Are the names something like CheckBox1....CheckBox30

--
Regards Ron de Bruin
http://www.rondebruin.nl



"ram" wrote in message ...
I have 30 check boxes on a spreadsheet I want to copy the values over to a
table to keep the history of the check box values each time the survey is
completed.

How can I Create a loop that retrives the value from each check box then
copies the value to the first blank row in my table. then changes the values
to all the checkboxes to false.

Thanks for any help