Move item from 1 listbox to another listbox

Solved/Closed
smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012 - Feb 19, 2011 at 10:55 PM
smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012 - Nov 18, 2012 at 06:09 AM
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
Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 27, 2011 at 04:54 PM
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
smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012
Nov 18, 2012 at 06:09 AM
thanks alot...worked like a charm using the tree control
0