How to distinguish between the first selected item in a combobox and no selected items

[Dafe]

Hi all,

I have a combobox on a userform where I would like the user to have the ability to add or delete items. To delete an item, I would like for the user to be able to select an item in the list and then click a [-] delete button. The problem that I'm experiencing is that .listindex = 0 when the first item is selected, but also when nothing is selected. How can I distinguish between the two situations to prevent the first item from being deleted when, in fact, nothing has been selected?

The If ... Exit Sub line, in the code below, prevents the first item from being deleted when nothing is selected. But, also prevents the first item from being deleted altogether.

Private Sub RemoveTagButton_Click()
       
    If Me.ListBoxTags.ListIndex <= 0 Then Exit Sub
       
    Me.ListBoxTags.RemoveItem (Me.ListBoxTags.ListIndex)
   
End Sub  

Thanks!

[shg]

The ListIndex property is -1 when nothing is selected.

[Dafe]

The ListIndex property is -1 when nothing is selected.

Thanks shg. You're right. The problem was that after deleting an item from the list, Excel doesn't automatically return the listindex to -1, even though nothing is visibly selected.

The solution in my case was to add an extra line of code to force the listindex back to -1 after each deletion.

Private Sub RemoveTagButton_Click() 
        
    If Me.ListBoxTags.ListIndex < 0 Then Exit Sub 
        
    Me.ListBoxTags.RemoveItem (Me.ListBoxTags.ListIndex) 
    Me.ListBoxTags.ListIndex = -1 
 
End Sub  

[shg]

Good job sorting it out. That would have surprised me as well.