title: Excel VBA to select from drop-down list
body: <p>I have written a VBA Macro in excel which creates spreadsheets from a template and updates values for individual spreadsheets based on options in a drop down list.</p>
  
  <p>I cant seem to figure out how to use VBA to choose the first option on the list.</p>
  
  <p>Any help appreciated. </p>