View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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