title: VBA-Excel How to clear ComboBox Items
body: <p>i have a ComboBox with 3 items as "Select","Jack" and "Jill". Under <strong>Private Sub Workbook_Open()</strong> I kept the following lines of code.</p>
  
  <pre><code>With ThisWorkbook.Sheets("Sheet1").ComboBox1
      Items.Clear
      .AddItem "Select"
      .AddItem "Jack"
      .AddItem "Jill"
  End With
  </code></pre>
  
  <p>When ever  i select an item and close the excel. Next time if i open the excel by default comboBox showing the previously selected item. But i want to show <strong>select</strong> as a default item.</p>