title: excel vba unloading contents from a form
body: <p>I have a userform that is opened when a user clicks a button in a worksheet. After clicking the button, if the user inputs some data, then decides to close the form, the previously entered data remains in the form. How can (in code) I get rid of that data so it opens with the default every time the button is clicked?</p>
  
  <p>Currently I just use</p>
  
  <pre><code>form.Show
  </code></pre>
  
  <p>when the button is clicked and</p>
  
  <pre><code>form.Hide
  </code></pre>
  
  <p>when the user hits the cancel button within the form.</p>
  
  <p>Thanks!</p>