Put a selected row into a listbox in a userform

hello everybody!

I am new using recently vba, i have a problem concerning a listbox!

I have an excel sheet with names.
my macro ask with an input which name do you want to delete.
Once you've put the name and press ok the entire row with the name and other informations is selected and the 'delete' userform opens.
I want to show in a listbox the selected row so the user see it and is sure to delete the right row!
Everything works in my macro except the listbox!

Can someone help me please!!?
Thank you!!Macro sebastien.xlsm

Thank you for your fast response! I tried your code and they tell me there is an error on : " vRow = Application.Match(CLng(SN), Range("C:C"), 0)"
I notices that you didn't write dim vRow as.... is it right like this?
Does it work on your pc?

And how could you do this thing without copying? I'm trying since yesterday at work and it doesn't work!!!
Thank you for your help!!

no i am actually using the code that i sent to you for another macro, i am just trying this feature on a small example you can put names instead of serial numbers!!

It's not working sorry!
Do you have an example where it works?

IN fact with this code the selected row appears in the listbox:

Please Login or Register  to view this content.

Now when I select in the listbox the item i want it to take the value and delete the row!
How cna i do that ?

Originally Posted by JosephP

here's your workbook with working code

to delete with your code you can use

Please Login or Register  to view this content.

THANK YOU VERY MUCH!! Everything is working now!!