Adding items to columns in a listbox
 

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

Adding items to columns in a listbox
 

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

Maybe you could add a label above the listbox?

Daniel Bonallack wrote:

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

--

Dave Peterson