endless loop for listbox_click()

[joseph.davidow]

Hi all,

I have a listbox1_click() sub and I would like to load a second listbox when the user chooses the item from listbox1. This part is ok.

However, as soon as the user chooses his item, I want to reset listbox1 (remove the selection). I thought of doing this with a loop:

For i = 0 To ListBox1.ListCount - 1
         If ListBox1.Selected(i) = True Then ListBox1.Selected(i) = False
    Next i

The problem with this is that it triggers the click event and I get into an endless loop.

any help is appreciated.