title: Excel VBA Combo box clear
body: <p>I am using excel 2010.</p>
  
  <p>I want to clear the content of a combo box in my sheet(clear to blank like when it's not selected), but I don't know how to select and clear. I tried to select a combo box like this:</p>
  
  <pre><code>Sheet1.ComboBox1.Clear
  </code></pre>
  
  <p>But no 'ComboBox' is under the Sheet1 object. The only to select my combo box is use this:</p>
  
  <pre><code>Sheet1.Shapes("Drop Down 24")
  </code></pre>
  
  <p>I don't know how to select and clear the content, can anyone help me?</p>