title: How to populate ComboBox and TextBox with text from a text file
body: <p>I'm new to vba and donot know much coding in vba. 
  Ive created a form in an excel workbook that contains a comboBox named <code>ComboBox1</code>and a textBox named <code>TextBox1</code>.</p>
  
  <p>And I have a text file that contains the following text:</p>
  
  <blockquote>
    <p>Organisation1|taxid001<br>
    Organisation2|taxid002<br>
    Organisation3|taxid003<br>
    Organisation4|taxid004  </p>
  </blockquote>
  
  <p>Here OrganisationX refers to Organisation name and taxidXXX refers to Tax ID of the corresponding organisation. </p>
  
  <p>When I load the form, <code>ComboBox1</code> should get filled with Organisation names and when I click on a particular item in the combobox containg the organization name, the corresponding Tax ID must get filled in <code>Textbox1</code>.<br>
  How do I do this? </p>