Hi!
I've listbox.columnheads = true. How supply heads in list
box? I supply listbox by property "list" but if
lisbox.columnheads = true heads is empty.
Can anyone assist?

Regards
Mark

Listboxes are wierd. If you supply the list items as a range, somethin
like A2:D9, then the listbox will pick up the items in A1:D1 as colum
heads if you set columnheads as true. But if you are programmaticall
adding the list items then it is not possible to have column heads.

- Manges

--
Message posted from http://www.ExcelForum.com

Hi Mangesh!
Thanks fo your satisfy reply, there is another limit in
excel.
Best regards
Mark

-----Original Message-----
Listboxes are wierd. If you supply the list items as a
range, something
like A2:D9, then the listbox will pick up the items in
A1:D1 as column
heads if you set columnheads as true. But if you are
programmatically
adding the list items then it is not possible to have
column heads.

- Mangesh


---
Message posted from http://www.ExcelForum.com/

.