title: Return the text from a dropdown box rather than the index number
body: <p>I have the following VBA code (from MS Access 2007). The code creates a new workbook and adds a dropdown to a cell. This small snippet adds a drop down to a particular cell and the adds some items to it.</p>
  
  <pre><code>Dim myRng As Range
  Dim myDD As Dropdown
  Set myRng = wSheet.Cells(row, col)
  With myRng
      Set myDD = .Parent.DropDowns.Add(Left:=.Left, Top:=.Top, Width:=.Width, Height:=.Height)
      myDD.AddItem "msg1"
      myDD.AddItem "msg2"
      myDD.LinkedCell = .Parent.Cells(row, col + 2).Address(external:=True)
  End With
  </code></pre>
  
  <p>This all works great and when I open the spreadsheet I get a combo box where I want and the items are displayed. However when I select an item the from the drop down in Excel the linked cell shows <code>1</code> or <code>2</code> (the index number). I would like it to show either <code>msg1</code> or <code>msg2</code>.  </p>
  
  <p>Is this possible?</p>