I am trying to remove all values from a Listbox in a Worksheet (not a Userform).
I can use this code to de-select all values, but I haven't been able to find a way to actually remove all items. I get a "method not supported by this object" if I try to use .Clear or RowSource = ""
Dim ws As Worksheet
Dim LB As MSForms.ListBox
Dim lCount As Long
Set ws = ActiveSheet
Set LB = ws.OLEObjects("ListBox2").Object
For lCount = 0 To .ListCount - 1
.Items(lCount) = False