title: Userform combobox take first value only - Excel VBA
body: <p>I have a user form set up which contains a ComboBox. The ComboBox is populated with values from a dynamic named range "List1" .. every thing is Fine .. when I choose the first value from the list it works and I could complete my tasks .. but when I choose another value from the list the value disappears and the combobox value become empty ..
  here is the code :</p>
  
  <pre><code>Private Sub ComboBox1_Change()
  ComboBox1.RowSource = "'[" &amp; ActiveWorkbook.Name &amp; "]DATA'!List1"
  ComboBox1.DropDown
  Worksheets("TEMP").Range("A3").Value = ComboBox1.Value
  End Sub
  </code></pre>
  
  <p>Could anyone give me a solution please ..</p>
  
  <p>UPDATE:
  I follow the instructions in this tutorial .. but I do it in a userform:
  <a href="http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions" rel="nofollow">http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions</a></p>