title: Excel VBA code for textbox value dependent on dropdown list value using named ranges
body: <h1>What I have:</h1>
  
  <ol>
  <li>I have a custom user form in Excel VBA. </li>
  <li>The form contains a dropdown list (<strong><em>industry category</em></strong>) and textbox (corresponding <strong><em>industry specifier</em></strong>).</li>
  <li>For each <strong><em>industry category</em></strong> there is one <strong><em>industry specifier</em></strong> (an acronym version of the category).</li>
  <li>The <strong><em>industry category</em></strong> and <strong><em>industry specifier</em></strong> will always be of the same row.</li>
  <li>The dropdown list is populated from a name range of cells.</li>
  </ol>
  
  <h1>What I need:</h1>
  
  <p>The value of the textbox needs to be dependent on the value of the dropdown-list.</p>
  
  <p>e.g. When an <strong><em>industry category</em></strong> is selected, the corresponding <strong><em>industry code</em></strong> should appear in the textbox.</p>
  
  <h1>My cell structure:</h1>
  
  <p>Column A (<strong><em>Industry Category</em></strong>):         </p>
  
  <pre><code>Agriculture                               
  Art and photography                       
  Arts and theatre                          
  Charity and non-profit                    
  Corporate                                   
  Educational and academic                
  </code></pre>
  
  <p>Column B (<strong><em>Industry Specifier</em></strong>):</p>
  
  <pre><code>ag
  ap
  at
  cn
  co
  ea
  </code></pre>
  
  <h1>My VBA code:</h1>
  
  <p>Populating the dropdown list for <strong><em>industry category</em></strong>:</p>
  
  <pre><code>'Populate Industry combo box.
  Dim range_c As Range
  Dim ws_c As Worksheet
  Set ws_c = Worksheets("4.1 List data")
  
  For Each range_c In ws_c.Range("IndustryList")
    With Me.Industry
      .AddItem range_c.Value
      .List(.ListCount - 1, 1) = range_c.Offset(0, 1).Value
    End With
  Next range_c
  </code></pre>
  
  <p>Textbox for <strong><em>industry specifier</em></strong>:</p>
  
  <pre><code>IndustrySpecifier.Value = ""
  </code></pre>
  
  <h1>What I've tried:</h1>
  
  <p>I've reviewed tutorials on how to achieve what I need using VBA code alone but I don't know where to begin using dependent named ranges</p>