Polling Checkboxes

[brucemc777]

I have a group of check boxes on a sheet. They can vary in number as I sometimes add or delete some.

I wish to run code to check status of the group at times as a collection, but after too many searches I can't find a predefined collection that these belong to. I suspect I will soon look into if it is possible for me to create a collection to group them in so I can run a loo to check them, but I thought I would appeal to cooler minds as right now I am near my "better just walk away" point.

If one has a "bunch" of check boxes on a page (where some option buttons also reside), is is possible to address them as a collection? I would like to:

Please Login or Register  to view this content.

Thoughts?

[mikerickson]

If your controls are from the Forms menu, perhaps something like this

Please Login or Register  to view this content.

[brucemc777]

I brought them in from the ActiveX group; I can't recall why I chose that but at some point an article pointed me in that direction. I am applying these to the worksheet itself, if that might be a factor...

In my "travels" I have seen reference to setting a variable to checkbox type and a collection called chaeckboxes, but I just keep getting errors. I am starting to think I might want to abandon that direction and think of another. The purpose is to designate any number of individuals out of a grouping that ranges from 12 to 20 to have a metric graphed; each time a change a sub is triggered that deletes all series and then displays all selected.

Thank-you for your thoughts; I suspect I best take a walk for the frustration level is getting fairly high and that leads to more mistakes...