Multiple list and combo boxes on userform send selection to bottom row of table - help required.

[dizzydunham]

So far I have learned how to populate the list boxes and combo boxes from the table and ranges. (userform)
I have learned how to send the multi selected items of 1 list box to a selected cell on command button click.
I have in the past sent values (textbox) to the bottom row of a table using row count method.

My problem(s) are sending selected items to the last row of the table rather than a selected cell. (I'm guessing I may be on right path but not laid the code out correctly)

AND how to work with more than 1 list box when sending the selections to the table.column.

Unlike textboxes I have found out you cant just send
.Offset (rowcount,5) = listbox.value
.offset (rowcount,6) = nextlistbox.value

searched the web for what feels like a life time - any pointers or code samples gratefully received.

 

[Fluff]

Have a look at post#2 here & see if it helps.
https://www.mrexcel.com/forum/excel...ulti-select-retrieve-results.html#post4441762

 

[dizzydunham]

Thanks for the link, It helped me see what I was after doing.

    Dim i As Long, strTemp As String
Dim j As Variant
Sheet1.Unprotect Password:=x
        For i = 0 To LISTCENTRE.ListCount - 1
            If LISTCENTRE.Selected(i) Then strTemp = strTemp & LISTCENTRE.List(i) & ", "
        Next i
 
    If Len(strTemp) Then
        strTemp = Left(strTemp, Len(strTemp) - 2)
        rowcount = Worksheets("VAF Tracker").Range("A1").CurrentRegion.Rows.Count
      Sheet1.Cells(rowcount, "B") = strTemp
   
        End If

I believe it was my lay out I had wrong and the link example showed clearly the way out for me.

Thanks yet again.

 

[Fluff]

Glad you got it sorted & thanks for the feedback