title: VBA Refer to TextBox or Label using a loop
body: <p>I am trying to replace the following:</p>
  
  <pre><code>txt1.Text = ""
  txt2.Text = ""
  txt3.Text = ""
  txt4.text = ""
  ...continues for quite awhile
  </code></pre>
  
  <p>With:</p>
  
  <pre><code>Dim cCont As Control
  
  For Each cCont In Me.Controls
  
  If TypeName(cCont) = "TextBox" Then
  'reset textbox value
     ???
  End If
  Next cCont
  </code></pre>
  
  <p>How do I refer to the textbox using the generic 'Control'?</p>