title: Populating combobox from named ranges
body: <p>I have created three dependent drop down lists using excel's validation formula. 
  <a href="https://i.stack.imgur.com/QexfH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QexfH.png" alt="enter image description here"></a>
  The benefit of this is that it is easy to add more options and the dropdown list updates automatically. The structure for this is seen below (where each range is given the same name as the column header). </p>
  
  <p><a href="https://i.stack.imgur.com/GEdKB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GEdKB.png" alt="enter image description here"></a></p>
  
  <p>Is it possible to create the same effect using combo boxes. I can find examples of populating a combo box from hand but not automatically from named ranges</p>