Listbox creating problems deleting a record

[PrimePorkchop]

I've figured out the majority of what I'm after, here, but I can't wrap my head around how to specify the listbox selection for the copying section of my code





What I want it to do is when you select a record from the listbox and hit "delete", it will first copy the record being deleted to a tab called "Deleted Log"

I'm able to delete the correct log from the listbox, BUT, the "copy" and "paste" method is copying the row that's selected on the worksheet, not the row that's selected in the listbox...




Attached is sheet, and code is below

Please Login or Register  to view this content.

[AlphaFrog]

acr = Me.assetLogDisplay.ListIndex + 2

[PrimePorkchop]

acr = Me.assetLogDisplay.ListIndex + 2

amazing how easily it comes to you.

Thank you so much for the help, works flawlessly

I'm just curious, for purposes of my learning... why +2? I know the code works, but I don't get what the +2 is telling excel to do

[AlphaFrog]

The first row in the listbox is index 0

The first data row on the sheet is 2

Add 2 to the index of the selected item on the listbox will be the sheet row number of the selected item.

You are doing the exact same thing here...
Sheet1.ListObjects(1).ListRows(.ListIndex + 1).Delete
...except the .ListRows(1) starts at row 2 on the sheet. So you only have to add 1 to the .ListIndex to get the .ListRow number (not the actual row number).

[PrimePorkchop]

Interesting... I still don't know why they're treated differently (listbox vs data row) - but - I have a lot of data now from you that I can begin exploring it

I appreciate the follow-up, thank you!