Hi

I want to fill some data in a Listbox throug listbox.column() = array.
It works fine, but vba does not recognise, that it should take the first
row from the array as columnheads. I switched the columnheads property
on by code, but there was no difference.
Does anybody know how to fill in the columnheads manually?

greez and thx
masterphilch

as far as i remember
columnsheads works only for ranges ..
and then shows the row ABOVE the rowsource.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


masterphilch wrote :

Hi

I want to fill some data in a Listbox throug listbox.column() =
array. It works fine, but vba does not recognise, that it should take
the first row from the array as columnheads. I switched the
columnheads property on by code, but there was no difference. Does
anybody know how to fill in the columnheads manually?

greez and thx
masterphilch

You do not include the headings in the array, and you set the Rowsource
property. So if the data is in A1:C10, and row 1 is headings, set
ColumnCount, set ColumnHeadings, and set RowSource to A2:C10.

--
HTH

Bob Phillips

"masterphilch" wrote in message
...
Hi

I want to fill some data in a Listbox throug listbox.column() = array.
It works fine, but vba does not recognise, that it should take the first
row from the array as columnheads. I switched the columnheads property
on by code, but there was no difference.
Does anybody know how to fill in the columnheads manually?

greez and thx
masterphilch