move item from 1 listbox to another listbox Solved/Closed

Question

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
Configuration: Windows XP / Internet Explorer 8.0

rizvisa1 · Answer

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 ?

smd_excel · Answer

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

Move item from 1 listbox to another listbox

2 responses

Similar discussions

Subscribe To Our Newsletter!