concatenate listboxes into one cell

[jsox79]

i have form that recalls data from one sheet and puts it in another.
i cannot figure out how to concatenate the boxes for the life of me, and have searched for hours.

basically i have listsboxes
ccity.list
cstate.list
czip.list
i would like to concat to city, state, zip

any help would be greatly appreciated

 

[AlphaFrog]

Sheets("Sheet1").Range("A1").Value = ListBox1.Value & ", " & ListBox2.Value & " " & ListBox3.Value

 

[jsox79]

figured out it
need to set the listbox.list to (0)
like so
ws.range(somerange) = listbox1.list(0) & ", " listbox2.list(0) & " " & listbox3.list(0)
that did the trick