I'm using a Multi Listbox Userform.
It contains two listboxes and an "Add" and "Remove" Button to populate listbox2 (Destination) two with the list from listbox1 (Origin). (I cannot yet post links or images)
I've added a transfer button, but I've no way to have it transfer all items from Listbox2 into the worksheet unless I first "select" all items in listbox2. I would like Listbox2's entire contents be transferred to the worksheet regardless of whether or not they've been "selected".
After all, the reason I'm using two Listboxes is to eliminate the need to "select" the items to be transferred. Thanks for all the help that's gotten me this far! You all are awesome!
Jeremie
It contains two listboxes and an "Add" and "Remove" Button to populate listbox2 (Destination) two with the list from listbox1 (Origin). (I cannot yet post links or images)
I've added a transfer button, but I've no way to have it transfer all items from Listbox2 into the worksheet unless I first "select" all items in listbox2. I would like Listbox2's entire contents be transferred to the worksheet regardless of whether or not they've been "selected".
After all, the reason I'm using two Listboxes is to eliminate the need to "select" the items to be transferred. Thanks for all the help that's gotten me this far! You all are awesome!
Jeremie