Deselecting selected listbox item.

[HighAndWilder]

Happy New Year Everybody

I'm not quite as happy as I would like to be but if someone can help me sort this teaser out I'll be on my way....

I select an item in a listbox and then run some code.

I set the listindex to -1 and then to deselect the apparently selected item I loop through the items and set the Selected array to false irrespective of what the current value is.

The selected item still appears to be selected after the code is run but listindex is -1.

What also happens is that the code is run twice, once when I select the item and then again when the listindex is set to -1.

If I throw a message up using MsgBox after or before I deselect all items than none of the items appear selected.

Also if I select item 0, the first one, then none of the items are selected.

Any ideas anybody? Cheers.

 

[Rick Rothstein]

Is the ListBox on a UserForm or on the worksheet?

Is the ListBox set to single select mode or multi-select mode (if multi, which one)?

Can you show us the code you are using that performs as you described above?

 

[NdNoviceHlp]

I think I've posted about this similar seemingly recursive problem... I'll see if I can find some links. I resolved this something like this..

Private Sub ListBox1_Click()
Dim LboxFlag As Boolean
If LboxFlag = False Then
LboxFlag = True
UserForm1.ListBox1.ListIndex = -1
Application.Wait (Now + TimeValue("0:00:01"))
UserForm11.ListBox1.Clear
UserForm11.ListBox1.AddItem "Re-Load Listbox code"
Else
LboxFlag = False
End If
End Sub

HTH. Dave
ps. should have included that where it says "Re-load Listbox Code" is where U enter your code to re-load your listbox

edit: I see Rick likely will have a better solution. Here's the link. I later added the Boolean for some reason?
https://www.mrexcel.com/forum/excel-questions/466168-phantom-listbox-selection.html