delete entire row selecting from listbox starting at specific row

i have a listbox that shows a worksheet data with 9 columns staring from row 16

i need help to modify a code i have ,that supposed deleted selected row from worksheet ,

but it should start counting from row 16 where data starts , but it starts deleting row 5 or row 6

Please Login or Register  to view this content.

thank you

Originally Posted by bluepomme

but it starts deleting row 5 or row 6

Are you sure?
Seems it deletes from 1st row when you select 1st item in the list.
Simply + 16 would do.

Please Login or Register  to view this content.

However, I don't think the below part will work...

Please Login or Register  to view this content.

thank you it works well just with

Please Login or Register  to view this content.

but it deletes row 16 if no row is selected on listbox , can you tell how to do , to only deleted the row you selected when its selected ?

sorry for my bad english

You need to control when no line is selected first.

Please Login or Register  to view this content.

thank you

but it shows a 424 error , do i need to make a set statement before ?

OOps.. sorry a typo...
Should be

Please Login or Register  to view this content.

It throws an 1004 error starting

Please Login or Register  to view this content.

OK... didn't see carefully.
Should be

Please Login or Register  to view this content.

thank you for your big help

now i just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

since i have 9 columns and its working fine

That's good.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.