Select one item from a listbox disables another listbox

[EagleInsight]

I have two listboxes that both have a different set of names. Can anyone help me with VBA coding that will disable a user from clicking an item in one listbox if an item has already selected an item in another listbox - on the same Userform.

Thanks,

[AlphaFrog]

Try something like this...

Private Sub ListBox1_Click()
   ListBox2.Enabled = ListBox1.ListIndex = -1
End Sub
    
Private Sub ListBox2_Click()
    ListBox1.Enabled = ListBox2.ListIndex = -1
End Sub

[EagleInsight]

Thanks alphafrog. It works in preventing me clicking on the other userform. However i also have a Clear selection button on the same userform using the below code:

Private Sub CommandButton1_Click()
UserForm1.ListBox1.ListIndex = -1
End sub

Private Sub CommandButton2_Click()
UserForm1.ListBox2.ListIndex = -1
End sub

What is now happening is once i select an item in one listbox and then clear it, i am disabled from clicking on the other listbox. Any advice?

[AlphaFrog]

When you clear a ListBox, enable the other as well.

Private Sub CommandButton1_Click()
UserForm1.ListBox1.ListIndex = -1
UserForm1.ListBox2.Enabled = True
End Sub
    
Private Sub CommandButton2_Click()
UserForm1.ListBox2.ListIndex = -1
UserForm1.ListBox1.Enabled = True
End Sub