PDA

View Full Version : Transfer data from one list box to another in a userform



cal911
04-03-2015, 11:39 AM
Hi guys,

I have a userform with two list boxes. Listbox A is pre-populated with the data from the previous userform and Listbox B is empty. My task is to let the user select one or more tasks from ListboxA and transfer them over to ListBoxB by using a horizontal spin button. The user should be able to transfer the tasks back and forth between the listboxes, but once a task is transferred it is no longer visible in the Listbox that stored it previously.

Any help on this would be greatly appreciated!

snb
04-03-2015, 02:05 PM
Listbox2.additem listbox1.List(listbox1.listindex)
listbox1.removeitem listbox1.listindex