title: How to use VBA to select the first iterm in a drop down list in Excel
body: <p>I used Data Validation to create some drop down lists. Anyone know how to use VBA to select the first iterm in a drop down list?</p>
  
  <p>I tried 'Split' function:</p>
  
  <pre><code>cell.Value = Split(cell.Validation.Formula1, ",")(0)
  </code></pre>
  
  <p>but it did not work well, it will only work if I put like "option1, option2" in the source in Data Validation window. If I refer the source to a range of options, then it will return with errors.</p>
  
  <p>I guess there should some smarter ways.</p>
  
  <p>Thanks!</p>