Tom

What if I forget about the headers and want to populate a multicolumn listbox. Can I do this with VBA

I have VBA code in which I want to populate a multicolumn listbox with values that are stored in a collection; they are not located (now) in a worksheet range

Thanks

Jo

----- Tom Ogilvy wrote: ----

You have use the rowsource (userform) or listfillrange (worksheet) propert
of the Combobox. Then, when you make headers true in the properties, i
uses the row above the specified range to get the header information. Yo
can't do it unless you bind the control to a range using one of the above

--
Regards
Tom Ogilv


"Joe" wrote in messag
..
Hello All
I am using Excel 2002 and am having trouble populating a 3 column listbo
with headers. Could someone provide a sample of code that I could mode
this by? The Xl help isn't that helpful with setting column headers an
populating the columns. Do I have to use a multi-dimensional array
Thanks
Jo