title: How to read the value of a drop down list on a sheet in Excel using VBA
body: <p>As per the title, i have a drop down list which is already populated. On a button command i want to read the selected value from this drop down list which i will use to drive an ADO query. </p>
  
  <p>I did VBA in Access years ago so have some idea of what i am doing but using it in Excel is new to me. </p>
  
  <p>As a side question can anybody point me in the direction of reference material for the types available in VBA excel or any VBA Excel programming resources?</p>
  
  <p>Thanks</p>