title: VBA - ComboBox with values inside a named range
body: <p>Good afternoon,</p>
  
  <p>I'm trying to load some values in a combobox using a combination of a named range and another combobox :</p>
  
  <pre><code>CBOX_NOMENCLAT.value = "SOCIAL"
  </code></pre>
  
  <p>When the value of this first combobox changes, it loads the second where I have my problem :</p>
  
  <pre><code>Private Sub CBOX_NOMENCLAT_Change()
      With CBOX_MOTIF
          .RowSource = Range(CBOX_NOMENCLAT)
      End With
  End Sub
  </code></pre>
  
  <p>I indeed have a named range called <code>"SOCIAL"</code> returning 3 values. I would like them to be loaded in my <code>CBOX_MOTIF</code> (see below "MOTIF OD").</p>
  
  <p><a href="https://i.stack.imgur.com/IXZes.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IXZes.png" alt="My 2 combo boxes"></a></p>
  
  <p>I thought about using the <code>INDIRECT</code> function but I couldn't find a way to make it work.</p>
  
  <p>Could you please help me? Thanks!</p>