title: How to Create Two Columns Lookup Combobox in Excel VBA UserForm
body: <p>Can you please let me know how I can create a Two columns Look up combobox in Excel VBA UserForm? I am looking to create some thing like this:</p>
  
  <p><img src="https://i.stack.imgur.com/WQmwP.png" alt="enter image description here"></p>
  
  <p>I know we can add Items to combobox using a method like this:</p>
  
  <pre><code>Private Sub UserForm_Initialize()
    With Me.ComboBox1
      .AddItem "215"
      .AddItem "316"
      .AddItem "485"
     End With
  End Sub
  </code></pre>
  
  <p>but I need to generate a associated value with 215,316,485 and so on valyes like hammer,...
  Thanks for your time,</p>