Changing the backcolor of all controls on a userform

[RawlinsCross]

Hi there,

I have a few dozen textboxes on a userform, might add a few, might take a few away. Looking to change the backcolor of them all. My first question is: are textboxes counted as controls? So I'm trying to write using the following code - any ideas?

Dim ctl As MSForms.Control
 
For Each ctl In Me.Controls
    Me.Controls.BackColor = RGB(211, 211, 211)
   'clearly not working here... 
Next ctl

 

[mikerickson]

For Each ctl In Me.Controls
    If TypeName(ctl) = "TextBox" Then
        ctl.BackColor = RGB(211, 211, 211)
    End If
Next ctl

 

[Norie]

Try this.

Dim ctl As MSForms.Control
 
For Each ctl In Me.Controls
    If TypeOf ctl Is MSForms.TextBox Then
        ctl.BackColor = RGB(211, 211, 211)
    End If
Next ctl