For each control Question

[yabbadabba]

Hi guys,
I have a userform with a multipage on it. On each multipage (3 of) there are several text boxes on each page. I have a code on page3 that will change the background colour if a criteria is met, however it also changes the background colour on the textboxes on the other pages.
Here is my code:

For Each ctrl In Me.Controls
If TypeOf ctrl Is msforms.TextBox Then
If ctrl.Value = "." Then ctrl.BackColor = RGB(255, 255, 255)
End If
Next ctrl

What i would like is that the textboxes on page3 of the multipage change colour only and not the text boxes on the other pages.
Any help would be appreciated. Thanks

 

[shg]

You could put the Multipage number in the Tag property of the control and test that.

 

[yabbadabba]

didn't work, but thanks

 

[Glory]

Every page of a multipage object is a separate container. You can iterate through all the controls on each page without touching the controls on any other page. Check out the "Pages" collection.

 

[Domenic]

Maybe...

[font=Verdana]    [color=darkblue]For[/color] [color=darkblue]Each[/color] Ctrl [color=darkblue]In[/color] Me.MultiPage1.Pages(2).Controls
        [color=darkblue]If[/color] TypeName(Ctrl) = "TextBox" [color=darkblue]Then[/color]
            [color=darkblue]If[/color] Ctrl.Value = "." [color=darkblue]Then[/color] Ctrl.BackColor = RGB(255, 255, 255)
        [color=darkblue]End[/color] [color=darkblue]If[/color]
    [color=darkblue]Next[/color] Ctrl[/font]

 

[yabbadabba]

Thanks Domenic, that worked

 

[Domenic]

You're welcome! And thanks for the feedback!