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