Listbox copy to cell range

[Purple_Sky]

Hi there,

Using the instructions at the link below, I created alistbox that will allow a user to select from the list, and with the push of abutton, those selections go over to Listbox2.

I would like to take this a step further and have theselected options from ListBox2 then be copied into a range of cells.

The idea here is that the “Listbox1” contains choices ofnegotiation points a person may want to use. “Listbox2” is where your selectionsare copied over to based on a button click of what you select. Then from here,I need to have these “Listbox2” options be copied to cell “B44” (and down). Ideallyeach option will populate a new cell (B44, B45, B46, etc…). B44 is in a newtable that asks different questions about the negotiation points that werechosen.

HELP ?

(Code used for Listboxes https://www.contextures.com/excelvbalistboxmove.html)

 

[Purple_Sky]

Can anyone offer some assistance. I need to have a list box select all items in the list box and then copy those to column B47, pasting down the column. Each selection goes in a new cell.