Listbox alternative where there is no drop down

[ipbr21054]

On a userform is there say a Listbox where you dont click the drop down or maybe a setting you can change so the results are just shown ?
Example like attched image

 

[ipbr21054]

This is where i am having the problem.
I have changed the text from the ComboBox now for the ListBox2.
When i open the userform i only see the customers name.
I should also see the date & item purchased.

This is the code, Do you see an error please.

    Private Sub populate()
    
        ' clear the Listbox
        Me.ListBox2.Clear
        ' declare variables
        Dim i As Long, lRow As Long, ws As Worksheet
        ' set ws to the desired sheet
        Set ws = Application.Worksheets("POSTAGE")
        ' determine the last row of that desired sheet
        lRow = ws.Cells(Rows.count, 1).End(xlUp).Row
        
        ' populate the Listbox by looping down the rows of ws
        With Me.ListBox2
            For i = lRow To 8 Step -1
                'determine if this customer should be added to combobox list
                If UCase(ws.Cells(i, 7).Value) = "POSTED" Then
                    .AddItem Cells(i, 2)    'adds the customer name to combobox first column
                    .List(.ListCount - 1, 1) = Cells(i, 1) 'add the date to second column of line just added
                    .List(.ListCount - 1, 2) = Cells(i, 3) 'add the item to third column of line just added
                End If
            Next i
        End With
    
    End Sub

Customers name is in column B

Date is in column A

Item purchased is in column C

 

[ipbr21054]

So in respect to the column issus above ive added the following to the Private Sub UserForm_Initialize

    With ListBox2
        .ColumnCount = 3
        .ColumnWidths = "250;130;100"
    End With

It now shows what i require.
Was that the correct thing to do or have i just created a workaround ?
Thanks

 

[DanteAmor]

It now shows what i require.

That's right, you must specify the number of columns in the ColumnCount property, otherwise, by default, it will only show you one column.

 

[ipbr21054]

I didnt use the column count in the properties field, so i hard coded it in the vba sheet

See attached.
Same thing i suppose ?

 

[DanteAmor]

The default value of the columncount property in the listbox is 1. If you set 0 then it does not show you any columns.
If you don't use the property then you have to do it in the code.