Hello, Im trying to add a range to a combobox with multiple columns. But for the life of me, i can't seem to get the second column to display.
I've tried to via the follwing code too but no luck:
For i = 1 To rngLstVC.Rows.Count
.AddItem rngLstVC(i, 1)
.List(.ListCount - 1, 1) = rngLstVC(i, 2)
Next
I've also tried creating a name range "VCTable".. (they all work but all only display the first column).
With frmSupplierMgt.cbSupplierType1
.ColumnCount =2
.List = ThisWorkbook.Sheets("Codes").Range("VCTable").Value
.BoundColumn = 1
.ColumnWidths = "20;100"
End With
This is the result i keep getting.. I need both values in the drop down but then the columnbound =1 to display in the combo box on selection.
Appreciate any help.
I've tried to via the follwing code too but no luck:
For i = 1 To rngLstVC.Rows.Count
.AddItem rngLstVC(i, 1)
.List(.ListCount - 1, 1) = rngLstVC(i, 2)
Next
I've also tried creating a name range "VCTable".. (they all work but all only display the first column).
With frmSupplierMgt.cbSupplierType1
.ColumnCount =2
.List = ThisWorkbook.Sheets("Codes").Range("VCTable").Value
.BoundColumn = 1
.ColumnWidths = "20;100"
End With
This is the result i keep getting.. I need both values in the drop down but then the columnbound =1 to display in the combo box on selection.
Appreciate any help.
