Label checkbox loop

Hello

I am trying to make a checkbox add a number into a label.

Example:

If a first checbox is checked, a number 1 will generate in another checkbox. If i uncheck the checkbox the number 1 will go away.

I figure that ill need a loop to loop through all "checkbox lables" and "number field lables" every time any checkbox is checked/unchecked.

What im trying so far:

Please Login or Register  to view this content.

For now im just testing if its possible to assign multiple labels a number through a loop, but its not working :/

Originally Posted by AlphaFrog

This is how you can loop through controls based on their base name ("Label_check" and "Label_nr") and a number if that's what you're asking.

Please Login or Register  to view this content.

Ty
That gives me a compile error: Method or data menber not found. If i add dim i as control i get another error: Type mismatch

Yes Label(activeX control)

on a worksheet

thank u very much

Now im trying to make a function that will run same code from different labels, but keep getting an error that function or sub are not defined.

Here is the code im trying to get to work:

Please Login or Register  to view this content.

The function is in a class module..
Any ideas?