columnshead with listbox

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
 
K

keepITcool

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 :
 
B

Bob Phillips

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

userform listbox columnheads 13
Userform Listbox column heads??? 1
Listbox Max Columns 2
Changing specific Listbox value 5
listbox control in VBA 1
Listbox Column Heading Help 1
ListBox.ColumnHeads Property 4
Adding Column Headings to a ListBox 2

Top