Can't add two columns to listbox in a userform

Question

I have two columns which I'm trying to add to a listbox. The first column has general numbers and the second one has time formatted numbers. When I select a column individually, it shows up in the listbox. The problem is, when I select them both, only the first one is added.

I'm using multiple listboxes and the ranges change in each iteration.

The code I wrote to populate the listboxes is this:

With Controls("Listbox" & k + 1)
        .RowSource = "Sheet1!" & Range(Cells(2, i), Cells(97, i + 1)).Address
End With

What could be happening?

basodre basodre · Accepted Answer · 2015-10-02T13:00:01

Did you set the ColumnCount property to 2 (either using code, or using the ListBox properties).

An example:

With Me.ListBox1
    .ColumnCount = 2
    .RowSource = "Sheet1!A1:B10"
End With

Can't add two columns to listbox in a userform

1 Answers