title: Combo Box (Indirect List)
body: <p>Good Morning</p>
  
  <p>I have a userform where I have 2 ComboBoxes:</p>
  
  <p>CB_AppData
  CB_App</p>
  
  <p>CB_AppData is an Excel List, whereas CB_App will be a list based in the value of CB_AppData (Basically an indirect function) </p>
  
  <p>So for Example:</p>
  
  <pre><code>For Each lAppData In xAppData.Range("App")
  Me.CB_AppData.AddItem lAppData.Value
  Next lAppData
  
  For Each lRevit In xRevit.Range("Revit")
  Me.CB_App.AddItem lRevit.Value
  Next lApp
  
  If CB_AppData.Value = ("Revit")
  CB_App.Value=lApp
  </code></pre>
  
  <p>However; for the above I can't seem to get it to work, can anyone advise?</p>