UserForm : Want to link Listbox1 with Listbox2 and delete data with one button

[HaroonSid]

hello
i m using listbox1 and listbox2 to delete data form two different NameRange and different sheets using two command button

i want, when i tick a box of first listbox1 than auto tick same value of listbox2 and delete the data with using one command Button not two,

thanx

[HaHoBe]

Hi, haroon2015,

I donīt see the necessity for 2 Listboxes with identical names as both lists could be handled in one ListBox. Due to the specifications you made the lists need to be identical as you refer to the position in the list and not to the name of the person (which would be more robust and allow different lists both on number of persons as of order of these). And to go into the future: no,I wonīt deliver code for this sceanrio as you didnīt ask for it in the opening post.

Code behind the UserForm:

Please Login or Register  to view this content.

Ciao,
Holger

[HaroonSid]

Hello, HaHoBe

i don't want to delete entire row, because there is data in other columns

i used ClearContents in my previous code

[HaHoBe]

Gi, haroon2015,

nobody is deleting entire rows unless you changed the code I supplied - when using Clearcontents maybe clear the contents of the second entry on the list and report back about what happens to the length of your list when you use that command...

Ciao,
Holger

[HaroonSid]

Yes U r Right, HaHoBe,

i was thinking wrong , code is working perfect, thanx alot HaHoBe

will add u reputation