title: Excel VBA Error in Listbox populating and unpopulating
body: <p>I am looking to populate a list box when a check box is ticked and empty it when the tick is removed.</p>
  
  <p>This code worked for this function in my previous modules but now I am getting an error (im guessing it is with the arguments for Range), and I would like to understand why. Additionally, the list box remains as it is when the checkbox is unticked.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Private Sub CheckBox1_Click()
      If Me.CheckBox1.Value = True Then
          ListBox1.List = Sheets("DATA").Range("C22").Value
      Else
          ListBox1.ListFillRange = ""
      End If
  End Sub
  </code></pre>