title: How to display second column in ComboBox after selection?
body: <p>I can click on my ComboBox and see the values of Column1 and Column2, but after I click on off the ComboBox, the value in Column1 is always displayed and I want the value of Column2 displayed.</p>
  
  <p><a href="https://i.stack.imgur.com/n27he.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/n27he.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/X7iH4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/X7iH4.png" alt="enter image description here"></a></p>
  
  <p>I tried this:</p>
  
  <pre><code>        With ComboBox2
              .Value = "None"
              .ColumnHeads = True
              .ColumnCount = 2
              .ColumnWidths = "50;100"
              .RowSource = "SetupQuestions!A42:B48"
              .BoundColumn = 2
          End With
  </code></pre>
  
  <p>That didn't set the value as I thought it would.</p>
  
  <p>I tried this:</p>
  
  <pre><code>Private Sub ComboBox2_AfterUpdate()
      ComboBox2.Value = ComboBox2.Column(2)
  End Sub
  </code></pre>
  
  <p>That didn't set the value as I thought it would.</p>
  
  <p>How can I force the ComboBox to display the value in Column2 after a selection is made?</p>