displaying multiple selections from a ListBox

[Cohen227]

I am wondering what the code would look like (and where I would put it) to diplay multiple selections from a ListBox into a text box. I know it will require a loop but I am not exactly sure what the format should be like. Ihope someone can help!!!

THANKS!

I currently have it set up so that one selection from the ListBox is displayed into the text box...

 

[JerryDennison]

The listbox must be set to multiselect. Then you must iterate through the ItemSelected to get the values to plug into your unbound control:

...
Dim varItem As Variant
dim txtTemp As String
For Each varItem in Me.ListBox.ItemsSelected
txtTemp = txtTemp & Me.ListBox.Column(ColumnNumber) & ", "
Next
txtTemp = Left(txtTemp, Len(txtTemp) - 2)
Me.TextBox = txtTemp
...

Where ColumnNumber is the column in the listbox that you want to display beginning with 0.