Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,524
- Office Version
- 365
- Platform
- Windows
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:
It brings back the data but only from Column A and I have verified in the immediate window that the address is correct.
and I can't for the life of me get it to diplay more than 1 column.
This is my code I'm using:
VBA Code:
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.