title: Populating a listbox with a range based on a combobox selection on a userform
body: <p>Upon picking a selection from a combobox dropdown list I want a listbox to display a specified range of results based on that selection.</p>
  
  <p>It is my understanding that a simple If/Then statement should suffice pending the use of the correct values and properties. </p>
  
  <p>I have one sheet (Sheet1) with two columns.</p>
  
  <p>Column A named "Letters" and Column B named "Numbers.<br>
   - In Column A range A2 = A, A3 = B, A4 = C, A5 = D.<br>
   - In Column B range B2 = 1, B3 = 2, B4 = 3, B5 = 4.</p>
  
  <p>I would like when range A2 is selected in combobox1 to display range B2 in listbox1.</p>
  
  <p>I would like to use and understand the simplest method.</p>
  
  <p>Here is a non-working example from using this thought process.</p>
  
  <pre><code>Private Sub ComboBox1_Change()
      If Me.ComboBox1.Value = "A" Then
          ListBox1.Value = Range(Sheet1!B2)
      End If        
  End Sub
  </code></pre>