title: Command button not re-enabling after condition not met automatically
body: <p>I have created a Command button and written a small code using if condition to match my criteria. Its working fine if their is any value in the cell/range, its doing according to code "asking to enter the data" and if their is any value "saying data is already enter" and disabling the button(what exactly i wanted).</p>
  
  <p>But, when i am re-entering the data/value into those cell, it's not re-enabling the button back automatically. I have to manually have to go to properties to enable it, which i don't want to do everytime.</p>
  
  <p>Below is my code"</p>
  
  <pre><code>Private Sub RESET_Click()
  If Range("A10").Value = "" Then
    Reset.Enabled = False
    MsgBox "Data has already updated for this period"
  Else
    Reset.Enabled = True
    MsgBox "Please, enter the data"
  End If
  End Sub
  </code></pre>
  
  <p>It's not re-enabling the button even after i have listed True in else condition. </p>
  
  <p>Please, also let me know if their is way. So, i can reset/re-enable this button on 1st of every month automatically using VBA. </p>
  
  <p>I would appreciate your response.</p>
  
  <p>Thanks</p>