<div>
You will need something like this<br />

<pre><code id="code-8164669">Sub ModControls()
    Dim ctl As MSForms.Control
    For Each ctl In UserForm1.Controls
        If TypeName(ctl) = &quot;Label&quot; Then
            ctl.BackStyle = fmBackStyleTransparent
        End If
    Next ctl
End Sub</code></pre>
</div>


You will need something like this


Sub ModControls()
    Dim ctl As MSForms.Control
    For Each ctl In UserForm1.Controls
        If TypeName(ctl) = "Label" Then
            ctl.BackStyle = fmBackStyleTransparent
        End If
    Next ctl
End Sub

<div>
Graham: I get a message that a <i>Object required</i> is required.<br />
Am I missing something?
</div>


Graham: I get a message that a Object required is required.
Am I missing something?

<div>
Hmm. It works OK for me. Which line gives the error?
</div>


Hmm. It works OK for me. Which line gives the error?

<div>
fantastic!<br />
Thanks a lot!
</div>


<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I have several controls (especially labels) which I would like to make transparent when the userform is initialized.<br />
<br />
How do I loop through all controls and change their properties?<br />
<br />
Thanks
</div>
</div>


Hi 

I have several controls (especially labels) which I would like to make transparent when the userform is initialized.

How do I loop through all controls and change their properties?

Thanks

How do I apply a property to all controls in a userform?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.