Hi,
Not tested but try this:

Dim myControl As MSForms.Control
For Each myControl In myForm.Controls
If TypeOf myControl Is MSForms.CheckBox Then
'something to do with myControl.Value
End If 'typeof
Next myControl

regards
Paul

(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