title: How to fix Error Code 424, Object Required
body: <p>I have an ActiveX Listbox and Combobox which I'm attempting to get the combobox list dynamically populated dependent on the listbox. The code works but I get the error</p>
  
  <blockquote>
    <p>Error Code 424, Object Required</p>
  </blockquote>
  
  <p>when opening the Excel. When debugging, it occurs at <code>ComboBox1.ListFillRange = "=ComboBox_Last6months"</code>.</p>
  
  <p>I've also tried without the <code>=</code> in front of the name range i.e. <code>ComboBox1.ListFillRange = "ComboBox_Last6months"</code></p>
  
  <p><code>ComboBox_Last6months</code> / <code>ComboBox_Lastquarter</code> / <code>ComboBox_Lastyear</code> are named ranges.</p>
  
  <pre><code>Sub ListBox1_Click()
      If ListBox1.ListIndex = 0 Or ListBox1.ListIndex = 3 Then
          ComboBox1.ListFillRange = "=ComboBox_Last6months"
          ComboBox1.ListIndex = 0
      ElseIf ListBox1.ListIndex = 1 Then
          ComboBox1.ListFillRange = "=ComboBox_Lastquarter"
          ComboBox1.ListIndex = 0
      ElseIf ListBox1.ListIndex = 2 Then   
          ComboBox1.ListFillRange = "=ComboBox_Lastyear"
          ComboBox1.ListIndex = 0
      End If
  End Sub
  </code></pre>