title: Retrieving both values from a 2 column ComboBox VBA
body: <p>I have a user form (excel, VBA) where there is a 2 column combobox. When user selects a certain value from the combobox, I want to get the value he selected, and the value associated with the first value (ie. the second column value).</p>
  
  <p>How do I do this? Simply <code>ComboBox1.Value</code> returns the value of the first column. <code>ComboBox1.Value(0)</code> doesn't work.</p>