title: Get dropdown value in VBA and get the name of the dropdown...nowhere to be found?
body: <p>I created a dropdown by dragging the combo box onto my sheet from the UserForm toolbar. I assigned some values to it from some cells in the book. Now I want some VBA code to access the selected dropdown item's value in the form of a string. </p>
  
  <p>My dropdown contains only text.</p>
  
  <p>Also how do I find the name of this newly created dropdown (it's nowhere in the properties!)?</p>