Add up check boxes in numerical order.

[Marq555]

Dear all

Does anyone know how to add up 1000 check boxes to a sheet so that excel would named them in numerical order: check box 1, check box 2.....
On the screenshot shown below I have renamed each of the check boxes manually.

screenshot.PNG


Regards

[Olly]

You could use a bit of code, something like:

Please Login or Register  to view this content.