delete selected row from user form

i have a problem while deleting the row in excel sheet from User Form.
when i search a data using search text box, it displayed in List Box1,but a problem arise if there are multiple search results(userform eg:smith).
then it is deleted only the first found, and not the result selected in listbox

So Please can any one do the correct code for me.

Waiting for reply,

qwzx

It deletes the selected row for me

basically you need to find the row associated with the record when you click on the record in the listbox. So some sort of entry reference number for each record would help

Hi qwzx
The cell reference was set up in

http://www.excelforum.com/excel-prog...ace-buton.html
so in the delet code

Please Login or Register  to view this content.

what did you try?

Hi qwzx
You will have to change the dimention of r to a long and then

Please Login or Register  to view this content.

column six of the list box is used to store the data lines row number