Move item from 1 listbox to another listbox

Solved/Closed
Report
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Hello,

need help on an excel listbox using vba.

i've got 2 listboxes on a form. listbox1 is being populated from an excel sheet. i need to move items (either one by one or all items) from listbox1 to listbox2 on a single click and also have the ability to remove items from listbox2(either one by one or all items). any help would be appreciated.

thanks

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
for list box you would have to loop thru items to locate where is the item location. Have you considered using a tree control instead of a list box control ?
1
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012

thanks alot...worked like a charm using the tree control
0