(Solved) – Remove a line or item selected on listbox of userform

  • by
(solved)-–-remove-a-line-or-item-selected-on-listbox-of-userform

I have a userform where I can enter some informations, but I want also to give the user the possibilty to delete the data that he entred by selecting it from listbox and then click on delete and they need to put a password
but unfortunately I tried this code that I found on youtube but it’s doesn’t work

Private Sub delete_Click()
Dim i As Integer
For i = 1 To Range("A65656").End(xlUp).Row
    If lstdiplay.Selected(i) Then
    Rows(i   1).Selected
    Rows(i).Select
    Selection.delete
End If
    Next i
End Sub

PICTURE OF LISTBOX

Leave a Reply

Your email address will not be published. Required fields are marked *