I have a listbox (listbox1) that is populating based on a combobox (cboSRegions) selection on a userform (frmOutreach). My data range is from A3:M with row 3 being column headings. cboSREgions search criteria is located in column B. My problem is I can get the listbox to display all the corresponding fields (13 columns of data) but it only displays it vertically in one column and not 13 columns of data horizontally. Here is my code that I am using:
'   Determining what is selected in combobox
    With cboSRegions

         SelectedREGION = .List(.ListIndex)
    End With

'   Getting LastRow number
    With Range("A:a")
        LastRow = .Cells(.Count, 1).End(xlUp).row
    End With

'   Filling ListBox
    ListBox1.RowSource = ""
    For Each Cell In Range("B4:m" & LastRow)
        If Cell.Value = SelectedREGION Then
        ListBox1.ColumnCount = 13
            ListBox1.AddItem Cell.Offset(0, -1)
            ListBox1.AddItem Cell.Offset(0, 0)
            ListBox1.AddItem Cell.Offset(0, 1)
            ListBox1.AddItem Cell.Offset(0, 2)
            ListBox1.AddItem Cell.Offset(0, 3)
            ListBox1.AddItem Cell.Offset(0, 4)
            ListBox1.AddItem Cell.Offset(0, 5)
            ListBox1.AddItem Cell.Offset(0, 6)
            ListBox1.AddItem Cell.Offset(0, 7)
            ListBox1.AddItem Cell.Offset(0, 8)
            ListBox1.AddItem Cell.Offset(0, 9)
            ListBox1.AddItem Cell.Offset(0, 10)
            ListBox1.AddItem Cell.Offset(0, 11)
        End If
    Next
Can you tell me what I am doing wrong? I also tried application.transpose but that didn't work. What I want is to display all 13 columns in one row based on combobox criteria. In other words, I want to display the entire row of data based on the criteria selected in the combobox. Also, if this is done, will the listbox be able to display all 13 columns using additem? If not, can you suggest a better way? Thank you in advance for any and all assistance.