Well, the Userform object has a Controls collection which you could
loop through and do a TypeOf comparison to test which are CheckBox.
However, you would make things easier on yourself if in the form's
_Activate event you put all the relevant checkboxes into your own
Collection, array or similar, then you'd *know* where to look for them
later.

--

(Andrew) wrote in message . com...
Folks,

Im hoping this is a simple question and Im just being dense.

I have a user form with around 30 check boxes, to select different
graphs to be displayed or hidden. I am wanting to cycle through the
checkboxes and then for each, if the user has checked the box display
the relevant series on the graphs. So the question is how do I step
from checkbox to checkbox to determine its value.

Thanks for any help,

Andrew