columnshead with listbox

  • Thread starter Thread starter masterphilch
  • Start date Start date
M

masterphilch

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 :
 
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.
 
Back
Top