title: Return the selected text from a dropdown box
body: <p>I am trying to return the text from a dropdown box that is selected on an Excel form. I have tried many things and the closest I have gotten is returning the index number. Also had a look at:</p>
  
  <p>Link: <a href="https://stackoverflow.com/questions/4078898/in-excel-vba-return-the-text-from-a-dropdown-box-rather-than-the-index-number">Return the text from a dropdown box rather than the index number</a></p>
  
  <p>I haven't found a working solution on that page. I have tried things such as:</p>
  
  <pre><code>ActiveSheet.DropDowns("DropDown1").Value
  ActiveSheet.DropDowns("DropDown1").Text
  ActiveSheet.DropDowns("DropDown1").SelectedValue
  ActiveSheet.Shapes("DropDown1").Value
  </code></pre>
  
  <p>etc.</p>