title: How to get the value of selected item in a xlDropDown which is added programmatically to a Excel sheet cell
body: <p>The following code shows the way i created the drop downs programmatically. It works fine. But now I need to get value of a specific dropdown of a cell.</p>
  
  <pre><code>Microsoft.Office.Interop.Excel.DropDowns xlDropDowns;
  Microsoft.Office.Interop.Excel.DropDown xlDropDown;
  xlDropDowns = ((Microsoft.Office.Interop.Excel.DropDowns)(sheet.DropDowns(Type.Missing)));
  xlDropDown = xlDropDowns.Add((double)rag.Left, (double)rag.Top, (double)rag.Width, double)rag.Height, true);
  var DropDownList = {"aaaa","bbbb","cccc","dddd"};
  
  int x = 0;
  foreach (var item in DropDownList)
  {
      x++;
      xlDropDown.AddItem(item);
  }
  </code></pre>
  
  <p>This is how i tried to get the xlDropDown value. currentCell is the cell where i have the drop down</p>
  
  <pre><code>ColumnVal = currentCell.Text; // This didnt give any output
  </code></pre>
  
  <p>OR</p>
  
  <pre><code>var dd = (Microsoft.Office.Interop.Excel.DropDown)currentCell.DropDowns(Type.Missing);
  </code></pre>
  
  <p>I know the 2nd one is wrong, because the cell range and drop down are 2 different things. But I tried all the options, still couldnt find any solution. Someone please help me</p>
  
  <p>More clearly, I want to access a specific cell(currentCell), and the xldropdown it contains and then get value from it</p>