title: fill the second combo box based on the first combo box
body: <p>I have 2 comboboxes in an excel userform and i need the first combobox to affect what is listed in the second. The table which i am getting the data from on a sheet in excel looks like image attached: </p>
  
  <p><a href="https://i.stack.imgur.com/8DCwk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8DCwk.png" alt="enter image description here"></a>.</p>
  
  <p>The data goes on with business names and individuals. What I would like <code>combobox2</code> to do is when say DT limited is selected in <code>combobox1</code> then <code>combobox2</code> will only show john and steve for selection.</p>
  
  <p>Can anyone help, I am new to this?</p>