title: How to change multiple comboboxes with little code
body: <p>Here's my problem.</p>
  
  <p>I have a userform with 10 comboBoxes. 
  Instead of Select Case al those comboboxes one by one is
  there a smart way to change <strong>multiple</strong> combobox properties such as backcolor or fontcolor?</p>
  
  <p>So for example:</p>
  
  <pre><code>Sub ChangeMultipleComboBoxes()
  Dim comboB as control
  
  For Each comboB In Me.Controls
  If TypeName(comboB) = "ComboBox" Then
  comboB.BackColor = vbRed
  End If
  Next comboB
  
  End Sub
  </code></pre>
  
  <p>The problem is that for comboB I can't seem to find any properties for changing it's backcolor or whatsoever.</p>
  
  <p>Can someone help me please?</p>