Loop to see if checkboxes is True

[nevrborn]

Hey,

I'm trying to make a macro that loops trough checkboxes and see if they are true. If they are a cell should be updated with a value. This is not on a userform.

This is my code, but I can't get it to work. The checkboxes are named Disp1 to Disp139. I have made the Controls("Disp" & i) work, but that was when using checkboxes on a userform.

Any help?

Please Login or Register  to view this content.

[mudraker]

This is one way providing the Checkboxes are from the Control Toolbox toolbar & not from the Forms toolbar

I also do not understand why you are only updating A3 in your posted code & using a variable for the row number

Please Login or Register  to view this content.

[nevrborn]

Thanks, this works better, but it dosen't work quite as I want it yet.

How can I differensiate between checkboxes? I have another 'set' of checkboxes in the same sheet, but those start with 'Act'...Act1, Act2 etc. The ones I want to check starts with 'Disp'.

The 'j' variable is updated (j=j+1)for each i, so I update 3, 4, 5 etc.

Thanks for all help

[nevrborn]

Still wondering about how I can differensiate between checkbox-groups, but I found out it was much easier to just have them named CheckBox 1,2 etc.

Now it works great

[mudraker]

If you still have them as different name then try

Please Login or Register  to view this content.