title: How to create complex dependent dropdown using VBA in Excel 2016?
body: <p>I have the following data in a worksheet called Parts.</p>
  
  <p><a href="https://i.stack.imgur.com/xEhRZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xEhRZ.png" alt="Parts Worksheet"></a></p>
  
  <p>In a <em>different</em> worksheet called Planning, I have the following data:</p>
  
  <p><a href="https://i.stack.imgur.com/IgRwI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IgRwI.png" alt="Planning Worksheet"></a></p>
  
  <p>In the above Planning Worksheet, Cell D3 is a dropdown that allow to choose a display language. The current choices are "English" and "Japanese". The A column's cells are also dropdown that allow to select a dimension.</p>
  
  <p>What I want to do is create a dropdown that:</p>
  
  <ol>
  <li>is dependent on the cell in the A column. The dropdown <strong>should filtered</strong> data from the Parts Worksheet according to the value of the corresponding A cell.</li>
  <li>is also dependent on the D3 Cell. The dropdown <strong>should display</strong> "English description" if D3 is "English" or "Japanese description" if D3 is "Japanese"</li>
  <li>once selected, the data in the dropdown <strong>should be the Part and not the description</strong>. In other words, it should behave like a select tag in HTML.</li>
  </ol>
  
  <p>I am new to VBA and after quite a lot of searching, I can't figure out how to do this. I would really appreciate a detailed answer. Thank you in advance!</p>
  
  <p>EDIT:</p>
  
  <p>The final Parts Worksheet will be at least 10,000 lines long. The user can't create named list manually. For this reason, I think I should use VBA.</p>