Adding items to columns in a listbox

  • Thread starter Daniel Bonallack
  • Start date
D

Daniel Bonallack

I have a two column listbox, called Listbox1.

I want to add the headers to the column heads, and then I want to add data
from my worksheet (but I don't want it bound to the data).

However, I'm not sure on the syntax
The column headers are "Company" and "SIB"
And the values in the first row would be Range("A2").value and
Range("B2").value

Could someone please help?

Thanks
Daniel
 
D

Dave Peterson

Column headings can only be specified if you use the .listfillrange/.rowsource.

Maybe you could add a label above the listbox?
 
Top