Select Cells from Listbox on Userform

[Jonathan78]

Hi all,

I use a listbox on a userform to show the data from range B2:B300
Is there a way to select the corresponding cell of the item selected in the listbox?

[royUK]

Use the ListBox's ListIndex. This starts from Zero so if the data starts in A1 the ListIndex+1, etc

[Jonathan78]

I'm not familiar with the ListIndex.
Would you mind taking a look at the attached sheet?

[royUK]

The code looks familiar.

The ListBox already has code to populate the textboxes based on clicking it

[Jonathan78]

But it doesn't work

[royUK]

What doesn't work, it looks like it's working to me.

What exactly are you trying to do?

[Jonathan78]

When the delete button is hit on the userform, it delete's the wrong item.
I'd like it to delete the selected item on the listbox

[Jonathan78]

Hello royUK,

I found the anwer on another thread, funny enough, given by you

    Dim I As Long
    With Me.ListBox1
        For I = .ListCount - 1 To 0 Step -1
            If .Selected(I) Then Sheets("DATA").Rows(I + 1).EntireRow.Delete
        Next I
    End With