Using a loop with several check boxes?

[450nick]

Hi all,

I have a loop function I'm writing and I want it to look through several text entry boxes in a userform. The boxes are names Race1, Race2, Race3 etc

I want to vary the box I'm looking at using a variable called Ra. Below is a sample line:

If Not Me.Race & Ra.Value = "" Then

This doesn't work but I'm not sure how to make it so the code 'sees' Race1 instead of Race & Ra. Any ideas?

Thanks!

 

[pbornemeier]

Something like this:

    For intX = 0 To Me.Controls.Count - 1
        If Me.Controls(intX).Name = "Race" & Ra Then
            If Me.Controls(intX).Value = True Then
                 'do stuff
            End If
        End If
    Next

 

[450nick]

Thanks for the reply, that works great. I would still like to be able to refer to them in the manner I described above if possible though..? I would like the macro in some instances to use the data from the next box as well, so I'll need it to be able to refer to "Race" & Ra and "Race" & Ra + 1 for example.

 

[Ruddles]

Instead of:-

Me.Race & Ra.Value

you need to do this:-

Me.Controls("Race" & Ra).Value

So for example:-

If Me.Controls("Race" & [COLOR=red][B]Ra[/B][/COLOR]).Value = Me.Controls("Race" & [COLOR=red][B]Ra+1[/B][/COLOR]).Value Then

 

[450nick]

Perfect, thanks very much for that