I have a MultiSelect ListBox (ActiveX) applied directly to a worksheet (liststyle Option -- the checkbox version). I am using the ListBox_Change event to trigger a sub that moves the selected items to a list on another worksheet. So far so good. (see code)
A half second or so after the selections are made, they are automatically cleared. They've been transferred to the appropriate place, so that's good -- but from the user's perspective, I'd like them to remain checked.
I'm using Excel 2007 on Windows 7.
I very much hope this is something obvious / stupid like I should be using a different event. I'm a relative newbie, so be gentle!
Thanks in advance.
Code:
Private Sub ListBox1_Change()
Dim i As Integer, li As Integer
i = 1
With ListBox1
For li = 0 To .ListCount - 1
If .Selected(li) = True Then
Worksheets("lists").Cells(10, 10).Offset(i, 0) = .List(li)
i = i + 1
End If
Next li
End With
Worksheets("lists").Cells(10, 11) = i - 1
End Sub
I'm using Excel 2007 on Windows 7.
I very much hope this is something obvious / stupid like I should be using a different event. I'm a relative newbie, so be gentle!

Thanks in advance.