title: Excel VBA, How to disable a commandbutton if one or more textbox is empty
body: <p>I made a UserForm with 1 CommandButton and 4 TextBox, what I'm trying to do is: I want to disable the CommanButton if all 4 TextBoxs are still empty.</p>
  <p>I already found code that works for only 1 text box:</p>
  <pre><code>Private Sub TextBox1_Change()
      If TextBox1.Value = &quot;&quot; Then
          CommandButton1.Enabled = False
      Else
          CommandButton1.Enabled = True
      End If
  End Sub
  </code></pre>
  <p>When I use the same code in TextBox2, I am stuck, the CommandButton is enabled.  When I use code (<code>if TextBox1.value &amp; TextBox2.value &amp; TextBox3.value &amp; TextBox4.value = &quot;&quot; then commandbutton1.enabled = false</code>),
  the CommandButton is still enabled after filling TextBox1.</p>