VBA Listbox question - Multiple Columns

[Scott Huish]

OK, I'm trying the example from this page: VBA Listbox - A Complete Guide - Excel Macro Mastery

and I can't for the life of me get it to diplay more than 1 column.

This is my code I'm using:

Private Sub UserForm_Initialize()
Dim c As Range, ws As Worksheet
Set ws = Worksheets("Brands")
With UserForm1.lstBrandsAvailable
    .Clear
    .RowSource = "Brands!" & Range(ws.Range("A2"), ws.Range("B2").End(xlDown)).Address
    .ColumnHeads = True
End With
End Sub

It brings back the data but only from Column A and I have verified in the immediate window that the address is correct.

 

[igold]

How about in the VBE properties window for the ListBox -> ColumnCount...

 

[RoryA]

Or add .ColumnCount = 3