UserForm with multi select : How can I submit the form and send the data into a column?

[wanders]

So I made a userform (picture above). This works so that I can add people from listbox1 to listbox2. That part is working.

But what I want to do is make it so that when you click submit all the names in listbox2. populate column A from A2 down (under my headers). This si the part I am confused by.

 

[wanders]

I meant to add, this is what I tried

Private Sub CommandButton3_Click()
Dim ws As Worksheet
Set ws = Worksheets("sheet2")
ws.Range("A2:A50").Value = ListBox2.Value

Unload Me
End Sub