Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,570
- Office Version
- 365
- 2016
- Platform
- Windows
I have a listbox in my userform. Its set us as a single selection. When the user clicks on it, they complete som data manipulation, and then the selection is eliminated from the listbox.
I have run into a problem. As the selections are removed one by one, eventually there is one left. It gets highlighted after the second last selection is removed. But clicking on this sole highlighted entry doesn't do anything anymore since clicking is no longer selecting the item as it's already selected.
What can I do to make this final listbox item clickable?
This is the code I am using to remove the item from the listbox.
I have run into a problem. As the selections are removed one by one, eventually there is one left. It gets highlighted after the second last selection is removed. But clicking on this sole highlighted entry doesn't do anything anymore since clicking is no longer selecting the item as it's already selected.
What can I do to make this final listbox item clickable?
This is the code I am using to remove the item from the listbox.
Code:
With test_mr.miss_rn
If .ListIndex >= 0 Then
.RemoveItem .ListIndex
End If
End With
Last edited: